Hi.
I have a column of first names, all in uppercase. i.e. BRIAN I am trying to convert to capitalized first letter with lower case else. i.e. Brian. I created a new column next to the first name col (col b), and I entered the formula
=left(b3,1)
But after entering it, I don't see "B" in the cell, but the actual formula.
Any ideas?
I have a column of first names, all in uppercase. i.e. BRIAN I am trying to convert to capitalized first letter with lower case else. i.e. Brian. I created a new column next to the first name col (col b), and I entered the formula
=left(b3,1)
But after entering it, I don't see "B" in the cell, but the actual formula.
Any ideas?