Jim,
Thank you...I didn't do a good job with my explanation...each name is
different as is the individual letter. So the first name column has steve,
tom, joe, etc and the letter column is ie, a, c, f, h, etc.

"Jim Thomlinson" wrote:

Could you do a find and replace (on the XL menu under edit)
--
HTH...

Jim Thomlinson


"steve in bristol" wrote:

I have columns with first names "Steve" and I want to them all to be
"Sunshine Steve" and I have another column with a letter ie "a" and I want to
make them all "24-a". Please advise