Separe columns in excel

excel, visual basic, VBscript, help, programming, macros

[mrfori]

Hi guys,

I need some help with excel.

I have a large excel file. On the first row I have data in the format of

8¦¦eza¦Edgar¦[e-mail]¦web45.com¦¦¦¦

I need to separate it in 5 columns and get rid of the '¦'

any idea how?

thanks a lot ..

[mrfori]

sorry .. on the first column I have the data

8¦¦eza¦Edgar¦[e-mail]¦web45.com¦¦¦¦

frank

[Timotheos]

In Excel go to the Data pull down menu and select Text to Columns... should be self explainatory from there.

[mrfori]

Ohh thanks a lot! .. it worked