Paul:
One more question, please. I now have a column where some of the cells have
a space as the first character. So, now I need a formula that will eliminate
the blank space, just leaving the rest of the text in the cell. I will
appreciate advice.

"Paul Corrado" wrote:

Select the cell then use

Copy/Paste Special and select Value

to copy the formula result over the formula. (If it is the entire column,
just highlight the whole column.)

Also, I should note that the formula posted by NHarkawat was a bit better
than mine. But I'm glad you were able to use what I gave you.