Ask a question Report Reply to this topic

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

therock90 - Mar 16, 2017 at 10:14 AM - Latest reply: Mazzaropi 1826 Posts Monday August 16, 2010Registration dateContributorStatus April 15, 2018 Last seen

- Mar 16, 2017 at 10:57 AM

Excel Ask a question Report Reply to this topic

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!

Cell to populate if other column has any text
Excel - Comparing cell A1 to entire A column in Sheet 2 » How-To - Excel
Change cell color based on another column [Solved] (Solved) » Forum - Excel
Paste data into alternate blank cells » Forum - Excel
Add Values in Excel in Columns that Contain Text » How-To - Excel
How to populate a version # change to a text sentence [Solved] (Solved) » Forum - Excel

1 reply

Report Respond to Mazzaropi

Mazzaropi 1826 Posts Monday August 16, 2010Registration dateContributorStatus April 15, 2018 Last seen - Mar 16, 2017 at 10:57 AM

Helpful

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