help with delimiters

[tommy_mo]

iwas wondering if anyone could hlpe with splitting a songle column into several new columns. The data is from an access file in which the flields have the following format:

1231222
1@yahoo.com

42424242
2@yahoo.com

So, whwn I import them into excel they have the format:
12343434||1@yahoo.com

I would like to split the column into seperate columns but can't figure out the delimiter to use. Any ideas??

 

[Vader]

All to easy...

Data->Text to columns->Delimited->Other->SHIFT+\

 

[tommy_mo]

sorry for taking so long to reply. Thanks for your help.