find replace assistance

  • Thread starter Thread starter ray
  • Start date Start date
R

ray

How can I insert text in the beginning of a cell using the
find/replace functionality. I have cells with data in
them and I want to add some common text to each cell at
the front of the data string. For example,
A1 bill
a2 phil
a3 paul

if I want to add say a dept number i.e 10 front of each
name in every cell, how do I do it?

/ray
 
Hi

I don't think you can do it with Find/Replace. You could use a helper
column, though.
Insert a new column and enter
="10"&A1
into the first cell and then fill down.
Once you are happy it is right, select the column Edit / Copy / Edit / Paste
Special / Values

Andy.
 
Back
Top