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?