ExcelBanter - Blank cell conversion to text

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Blank cell conversion to text (https://www.excelbanter.com/new-users-excel/4561-blank-cell-conversion-text.html)

MaryMMG

Blank cell conversion to text

If I have a column of blank cells, how do I formulate to make them read as
text?

JE McGimpsey

One way:

Select the column and choose Cells/Number/Text from the Format menu.

In article ,
"MaryMMG" wrote:

If I have a column of blank cells, how do I formulate to make them read as
text?

All times are GMT +1. The time now is 01:32 PM.