Replacing Text Strings

Good Afternoon,

I'm looking to replace my field headers, with others. Name into First Name, Surname into Last Name...etc.

See attached spreadsheet.

Everytime I try Find & Replace with VB, it will Replace EVERY occurence of "name". So I end up with; First Name, SurFirstName...

Which is very annoying! I've got half way through another fix (by finding out the address of what I want to replace, rather than the string itself), but want VB to do all the work...

Any help is appreciated.

Thanks!

N.

You could do this with a lookup table

paste the following in to a cell (say A2), then replicate right. You can then copy/paste values back in to the 1st row, if you need to.

=VLOOKUP(A1,$A$10:$C$12,3,FALSE)

Is this what you were trying to do, or have I misunderstood?

Cheers

Mat

thanks,

i'm looking for something more like this...

http://www.excelforum.com/excel-work...d-replace.html

this looks to be exactly what i need, but cant get it to work...

any ideas?