THANK YOU SO MUCH! Have a great day!

"Paul C" wrote:

This formula should do the trick.

=UPPER(LEFT(TRIM(A1)))&RIGHT(TRIM(A1),LEN(TRIM(A1) )-1)

enter it in a unused column, Copy down and then Copy-Paste Special Values
back to column A
--
If this helps, please remember to click yes.


"LeisaA" wrote:

In a column, for 3400 rows, How do I get rid of an unwanted space preceding
the sentence and make sure the first letter of the sentence is capitalized.