Replace entire cell content
 

I have a bunch of names on a spreadsheet and i'm looking for an easy way to
replace the names in each cell with a single character, 1, x, etc.

Replace entire cell content
 

Details along with before/after examples

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Steve C" wrote in message
...
I have a bunch of names on a spreadsheet and i'm looking for an easy way to
replace the names in each cell with a single character, 1, x, etc.