Capitalize first letter of every word

**inspirone1505** · 02-19-2007, 07:24 PM

Hi,

How do I automatically capitalize the first letter of every word in an excel cell?

Thanks.

Ins

**VBA Noob** · 02-19-2007, 07:27 PM

Hi,

Use a helper column. Say data in Col A enter this in B1 and drag down

=PROPER(A1)

Then paste special values

VBA Noob

**inspirone1505** · 02-19-2007, 07:33 PM

I guess I am too novice to understand your reply. I hope you can say it in layman terms (without functions and equations).

**VBA Noob** · 02-19-2007, 07:40 PM

Does this help

VBA Noob

**inspirone1505** · 02-19-2007, 07:54 PM

That is genius

and generous of you! Thanks very much.

**VBA Noob** · 02-20-2007, 03:06 AM

Glad it helped

VBA Noob