Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
VBA for Excel 2000 file is corrupt | Excel Discussion (Misc queries) | |||
Stop Excel Rounding Dates | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Excel error - Startup (and Acrobat PDFMaker) | Setting up and Configuration of Excel |