software

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: www.excelforum.com/member.php...oamp;userid=31338
View this thread: www.excelforum.com/showthread...hreadid=526187Data gt; TextToColumns gt; Delimited gt; use Underscore as the delimiter and follow
the menu

Vaya con Dios,
Chuck, CABGx3
quot;exceluser2quot; wrote:

gt;
gt; id:1132565475_376458
gt; id:1142565475_376239
gt; id:1136654745_376665
gt;
gt; I would like to split the above into the 2 new collumns
gt;
gt; collumn1 collumn2
gt; 1132565475 | 376458
gt; 1142565475 | 376239
gt; 1136654745 | 376665
gt;
gt; thanks for the help
gt;
gt;
gt; --
gt; exceluser2
gt; ------------------------------------------------------------------------
gt; exceluser2's Profile: www.excelforum.com/member.php...oamp;userid=31338
gt; View this thread: www.excelforum.com/showthread...hreadid=526187
gt;
gt;

And then select that first column and

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

CLR wrote:
gt;
gt; Data gt; TextToColumns gt; Delimited gt; use Underscore as the delimiter and follow
gt; the menu
gt;
gt; Vaya con Dios,
gt; Chuck, CABGx3
gt;
gt; quot;exceluser2quot; wrote:
gt;
gt; gt;
gt; gt; id:1132565475_376458
gt; gt; id:1142565475_376239
gt; gt; id:1136654745_376665
gt; gt;
gt; gt; I would like to split the above into the 2 new collumns
gt; gt;
gt; gt; collumn1 collumn2
gt; gt; 1132565475 | 376458
gt; gt; 1142565475 | 376239
gt; gt; 1136654745 | 376665
gt; gt;
gt; gt; thanks for the help
gt; gt;
gt; gt;
gt; gt; --
gt; gt; exceluser2
gt; gt; ------------------------------------------------------------------------
gt; gt; exceluser2's Profile: www.excelforum.com/member.php...oamp;userid=31338
gt; gt; View this thread: www.excelforum.com/showthread...hreadid=526187
gt; gt;
gt; gt;

--

Dave Peterson

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:
gt; And then select that first column and
gt;
gt; Edit|Replace
gt; what: id:
gt; with: (leave blank)
gt; replace all
gt;
gt; CLR wrote:
gt;gt; Data gt; TextToColumns gt; Delimited gt; use Underscore as the delimiter and follow
gt;gt; the menu
gt;gt;
gt;gt; Vaya con Dios,
gt;gt; Chuck, CABGx3
gt;gt;
gt;gt; quot;exceluser2quot; wrote:
gt;gt;
gt;gt;gt; id:1132565475_376458
gt;gt;gt; id:1142565475_376239
gt;gt;gt; id:1136654745_376665
gt;gt;gt;
gt;gt;gt; I would like to split the above into the 2 new collumns
gt;gt;gt;
gt;gt;gt; collumn1 collumn2
gt;gt;gt; 1132565475 | 376458
gt;gt;gt; 1142565475 | 376239
gt;gt;gt; 1136654745 | 376665
gt;gt;gt;
gt;gt;gt; thanks for the help
gt;gt;gt;
gt;gt;gt;
gt;gt;gt; --
gt;gt;gt; exceluser2
gt;gt;gt; ------------------------------------------------------------------------
gt;gt;gt; exceluser2's Profile: www.excelforum.com/member.php...oamp;userid=31338
gt;gt;gt; View this thread: www.excelforum.com/showthread...hreadid=526187
gt;gt;gt;
gt;gt;gt;
gt;


hi!

better you go for Text To Columns and choose fixed width and then opt
for quot;Do not Import Columnquot; option!

-via135exceluser2 Wrote:
gt; id:1132565475_376458
gt; id:1142565475_376239
gt; id:1136654745_376665
gt;
gt; I would like to split the above into the 2 new collumns
gt;
gt; collumn1 collumn2
gt; 1132565475 | 376458
gt; 1142565475 | 376239
gt; 1136654745 | 376665
gt;
gt; thanks for the help--
via135
------------------------------------------------------------------------
via135's Profile: www.excelforum.com/member.php...oamp;userid=26725
View this thread: www.excelforum.com/showthread...hreadid=526187