Report

Cell to populate if other column has any text

Ask a question therock90 - Last answered on Mar 16, 2017 at 10:57 AM by Mazzaropi
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!

Helpful
+0
plus moins
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
Leave a comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!