Did you use Edit/Paste Special/Values when you pasted the values back
into column A?

If so, you've not given enough information to make an analysis. What
does "Didn't work" mean? Crash? Didn't copy? Wrong values? Wrong
Formulae? something else?


In article ,
"Lynn in Tulsa" wrote:

I've used the suggestions here to change all lower case names to Proper and
to no avail. Column A has the names. I put the formula in B and then did
the copy values back to A. Didn't work. What did I do wrong?