change cell contents
 

Hi,
In various cells across a spreadsheet , I need to replace the contents of
the cell with a concatenated text.

eg, I have say, '100' in several cells across the sheet, I need to replace
it all with 'Days 100'.

how can I do that?

change cell contents
 

Do a find and Replace (Ctrl + H). Set it for exact matches only. Find 100 and
replace with Days 100
--
HTH...

Jim Thomlinson


"Mary" wrote:

Hi,
In various cells across a spreadsheet , I need to replace the contents of
the cell with a concatenated text.

eg, I have say, '100' in several cells across the sheet, I need to replace
it all with 'Days 100'.

how can I do that?

change cell contents
 

Hi,
sorry I havent being clear to state my need. Actully I found the answer in
another thread here.
thanks a lot for replying anyway

Mary

"Jim Thomlinson" wrote:

Do a find and Replace (Ctrl + H). Set it for exact matches only. Find 100 and
replace with Days 100
--
HTH...

Jim Thomlinson


"Mary" wrote:

Hi,
In various cells across a spreadsheet , I need to replace the contents of
the cell with a concatenated text.

eg, I have say, '100' in several cells across the sheet, I need to replace
it all with 'Days 100'.

how can I do that?