Hi Jerry,

Am Mon, 24 Sep 2012 07:15:24 -0700 (PDT) schrieb :

I have a .csv file with information in columns A,B,C, D. The information in column d is formated like this: AL Corp of Eng; ; 205-497-9828
I need to move the phone number into Column E, and delete the two simicolons. There is about 1200 rows of information that needs to be changed.
Could someone show me how to do this?

select your column D = Data = Text to Columns = Delimited =
Delimiter = Semicolon = second column with the space "Do not import
this column (skip) = Finish


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2