So, for example, replace Phn with 'Phn and Supp with 'Supp. Cool idea.
Thank you very much.
--
Mike S.


"Sandy Mann" wrote:

Yes I see what you are saying - if you use the Edit Replace option Excel
*helpfully* reformats the cell for you'

The answer is to precede all entries with a single apostrophe. The
apostrophe will not show but it will tell Bill Gates that you want it to
remain as text

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk