Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel

Cell to populate if other column has any text [Closed]

Report
-
Posts
1843
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
October 29, 2020
 -
Hello,

I'm struggling to find a formula to populate one column's cell based on another column's cell having at least one character of text.

e.g. A1 would insert a "Y" if B1 has text

Any help would be most appreciated!

See more

1 reply

Answer 1 / 1
Posts
1843
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
October 29, 2020
 136
therock90, Good morning.

Try to use:

=IF(ISTEXT(B1), "Y", "")

Is that what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Ask a question