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?

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?

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?