Cell to populate if other column has any text
Closed
therock90
-
Updated by therock90 on 16/03/17 at 10:14 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Mar 16, 2017 at 10:57 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Mar 16, 2017 at 10:57 AM
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!
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!
Related:
- Cell to populate if other column has any text
- Count if cell contains number - Excel Forum
- How to delete column in word - Guide
- If cell contains date then return value ✓ - Excel Forum
- Excel: If Date =, then enter a value ✓ - Excel Forum
- Excel formula to check if cell contains a date - Excel Forum
1 response
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Mar 16, 2017 at 10:57 AM
Mar 16, 2017 at 10:57 AM
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
Try to use:
=IF(ISTEXT(B1), "Y", "")
Is that what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
