Edit File Information

[easleyjw]

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?

Thanks,
Jerry

 

[Claus Busch]

Hi Jerry,

Am Mon, 24 Sep 2012 07:15:24 -0700 (PDT) schrieb (e-mail address removed):

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

 

[easleyjw]

Hi Jerry,



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








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

Thank you very much! That worked like a champ. Now in the column that is formatted for phone numbers, when I click on some of the numbers, they show up in different formatting in the formula bar. They show up like this:

6155484521 even though in the cell it is formatted like this (615) 548-4521
and some of them show like this: (864) 443-2457 in the formula bar which is the same as it is in the cell.

Best I can tell, some of the numbers have a space in front of the string. Could you tell me how to remove any spaces from the front of the numbers in the entire column?

Thanks,
Jerry

 

[Claus Busch]

Hi Jerry,

Am Mon, 24 Sep 2012 16:11:36 -0700 (PDT) schrieb (e-mail address removed):

Now in the column that is formatted for phone numbers, when I click on some of the numbers, they show up in different formatting in the formula bar. They show up like this:

6155484521 even though in the cell it is formatted like this (615) 548-4521
and some of them show like this: (864) 443-2457 in the formula bar which is the same as it is in the cell.

Best I can tell, some of the numbers have a space in front of the string. Could you tell me how to remove any spaces from the front of the numbers in the entire column?

if there is a 10 digit number in the formula bar, then in the cell is a
10 digit number custom formatted as (000) 000-0000
If it looks in formula bar and cell the same, the cell is formatted as
text
To remove spaces in front you can use TRIM


Regards
Claus Busch