Hi

Try entering in another column to the right of all of your contact fields
="'"&A1 where A is the column you wish to change. Change letter for each
successive column you need to alter.
Copy down the column(s)

Copy the whole range of new Data Paste SpecialValues to "fix" the values
as absolute values instead of formulae.

You did say append. If you truly meant that, then change the formula round
to put the "'" after the cell value.
=A1&"'"


Regards

Roger Govier


WhoC@nItbN0W wrote:
I need to import my 'excel based' contact list into Outlook2003. However, to
do this the character ' needs to be appended to all cells if Outlook has to
read the data.
Any idea on how to do this?

Regards