Apply Trim and Proper Case to multiple cells at one time

[Leesha]

Hi,
I have a spreadsheet that I need to set each cell to Proper case and I need to trim any cells with spaces preceeding the word. Is there a way to do multiple columns at one time? I can do I column at a time but at this rate its going to take me forever.
Thanks,
Leesha

[Rudi]

If you create the formula on the right hand side of your data, you can then fill the formula down AND across so that if acts on every column containing the text values. Then just copy the entire block or corrected output and paste values over the original columns.

Here is a formula that will only propercase the TEXT and leave dates and numbers as is.
You will need for format dates back to date formatting though.
=IF(ISTEXT(A2),PROPER(A2),A2)

See attached workbook for sample...

[Leesha]

Thanks! Worked like a charm!
Leesha

[Rudi]

Sorry, I forgot to add the TRIM() function in there, but I'm sure you've fixed that oversight

[Leesha]

Yep!! I just needed to be pointed in the right direction LOL!