Splitting text into 2 collumns

[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

[CLR]

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

Vaya con Dios,
Chuck, CABGx3



"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
>
>
> --
> exceluser2
> ------------------------------------------------------------------------
> exceluser2's Profile: http://www.excelforum.com/member.php...o&userid=31338
> View this thread: http://www.excelforum.com/showthread...hreadid=526187
>
>

[Dave Peterson]

And then select that first column and

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

CLR wrote:
>
> Data > TextToColumns > Delimited > use Underscore as the delimiter and follow
> the menu
>
> Vaya con Dios,
> Chuck, CABGx3
>
> "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
> >
> >
> > --
> > exceluser2
> > ------------------------------------------------------------------------
> > exceluser2's Profile: http://www.excelforum.com/member.php...o&userid=31338
> > View this thread: http://www.excelforum.com/showthread...hreadid=526187
> >
> >

--

Dave Peterson

[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

Dave Peterson wrote:
> And then select that first column and
>
> Edit|Replace
> what: id:
> with: (leave blank)
> replace all
>
> CLR wrote:
>> Data > TextToColumns > Delimited > use Underscore as the delimiter and follow
>> the menu
>>
>> Vaya con Dios,
>> Chuck, CABGx3
>>
>> "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
>>>
>>>
>>> --
>>> exceluser2
>>> ------------------------------------------------------------------------
>>> exceluser2's Profile: http://www.excelforum.com/member.php...o&userid=31338
>>> View this thread: http://www.excelforum.com/showthread...hreadid=526187
>>>
>>>
>

[via135]

hi!

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

-via135

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