Icon as cell value using array formula

0
votes

I want an arrow icon (▶) in all cells in a column. For a single cell I use =char(HEX2DEC("25B6")). How do I enter this as an array formula?

2
google-sheetsarray-formulasgoogle-sheets-formula

2 Answers

1
votes

For me the existing answer does not work, but this does:

=ArrayFormula(if(row(A1:A),char(9654),))
1
votes
=ARRAYFORMULA(SUBSTITUTE(A1:A10&CHAR(HEX2DEC("25B6")), 0, ))

0

alternatives:

=ARRAYFORMULA(IF(ROW(A1:A10), "▶", ))

=TRANSPOSE(SPLIT(REPT("♀▶", 10), "♀"))