| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Splitting text into 2 collumns
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Splitting text into 2 collumns
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Splitting text into 2 collumns
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Splitting text into 2 collumns
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Splitting text into 2 collumns
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| moving text from a word document to excel | New Users to Excel | |||
| Text Wrapping | Excel Discussion (Misc queries) | |||
| SUMPRODUCT vs Text??? | Excel Worksheet Functions | |||
| Autofitting a row | Excel Discussion (Misc queries) | |||
| Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Linear Mode
