Splitting text into 2 collumns

E

exceluser2

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
 
D

Dave O

Just for safety, try this on backed up data so you don't accidentally
lose anything.

Highlight the range or column and on the menu click >Data >Text To
Columns. In the resulting window, select Delimited and click Next. In
the Delimiters box, de-select anything that is checked, and select
Other, then enter an underscore. Click Next, then Finish, and your
desired results will appear.

If you want to get rid of the "id:" you can do a search and replace:
find id:, replace with nothing.
 
C

CLR

Data > TextToColumns > Delimited > use Underscore as the delimiter and follow
the menu

Vaya con Dios,
Chuck, CABGx3
 
D

Dave Peterson

And then select that first column and

Edit|Replace
what: id:
with: (leave blank)
replace all
 
A

Alan Beban

Or do TextToColumns twice,using Underscore as the delimiter the first
time, and Colon as the delimiter the second time checking do not import
column.

Alan Beban
 
V

via135

hi!

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

-via135
 
Top