hi!

better you go for Text To Columns and choose fixed width and then opt
for "Do not Import Column" option!

-via135


exceluser2 Wrote:
id:1132565475_376458
id:1142565475_376239
id:1136654745_376665

I would like to split the above into the 2 new collumns

collumn1 collumn2
1132565475 | 376458
1142565475 | 376239
1136654745 | 376665

thanks for the help


--
via135
------------------------------------------------------------------------
via135's Profile: http://www.excelforum.com/member.php...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=526187