Thanks..it worked great! can you answer my 2nd posting question which was

have entire column of addresses ie. 122main st and need to change to 122
Main St--is there a formula for this?

"max power" wrote:

you can use the formula Proper

just type in a cell next to it =Proper(cell)

this will change all the text to have uppercase first letter and lowercase
for each letter after that

if your still unsure use the FX button next to the formula bar and sellect
the proper formula

regards max

"lori12844" wrote:

I have a column of names and I would like to change just the 1st letter of
each name to upper case-how do I do that?