Using excel to modify a CSV for internatilising outlook contacts
 

Afternoon all,

I have about 300 phone numbers in the standard UK format of 01603229920.

I wish to somehow turn 01603229920 into +441603229920, 300 times!

I've exported the outlook contacts to CSV, but there doesn't seem to be
an easy way of doing this. Search and replace is not an option I don't
think but I've had a crap day and might be missing something obvious.
--
Regards
Jon

If it always start with a zero and yopu want to replace that zero with +44
you can do that using Word which allows for replacing the first character
with for instance

<*

replace with

+44

however in Excel you would need eithe amacro or a help formula

something like

=SUBSTITUTE(A1,0,"+44",1)

Regards,

peo Sjoblom

=SUBSTITUTE(A1,0,"+44",1)

"Jon" wrote:

Afternoon all,

I have about 300 phone numbers in the standard UK format of 01603229920.

I wish to somehow turn 01603229920 into +441603229920, 300 times!

I've exported the outlook contacts to CSV, but there doesn't seem to be
an easy way of doing this. Search and replace is not an option I don't
think but I've had a crap day and might be missing something obvious.
--
Regards
Jon