| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Import text doc to XL. Need items seperated by " " in new column
Hello,
I am wondering if there is a way to take a text line "0.29 I IF IGI 1238" and seperate it into columns based on where the space " " occurs? Column A - 0.29 Column B - I Column C - IF Column D - IGI Column E - 1238 Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Import text doc to XL. Need items seperated by " " in new column
DataText to ColumnsDelimited by "space"
Gord Dibben MS Excel MVP On Tue, 21 Nov 2006 10:22:01 -0800, irvine79 wrote: Hello, I am wondering if there is a way to take a text line "0.29 I IF IGI 1238" and seperate it into columns based on where the space " " occurs? Column A - 0.29 Column B - I Column C - IF Column D - IGI Column E - 1238 Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Import text doc to XL. Need items seperated by " " in new column
If it's a separate text document, use Excel, File/ Open, txt documents,
browse to yours, choose delimited, select space as the delimiter. If it's already in Excel in one column, use Data/ Text to Columns/ Delimited/ select space. -- David Biddulph "irvine79" wrote in message ... Hello, I am wondering if there is a way to take a text line "0.29 I IF IGI 1238" and seperate it into columns based on where the space " " occurs? Column A - 0.29 Column B - I Column C - IF Column D - IGI Column E - 1238 Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumproduct issues | Excel Worksheet Functions | |||
| macro | Excel Discussion (Misc queries) | |||
| parsing text in a multiple column count | Excel Worksheet Functions | |||
| text import all in one column. how do I set it to multiple column | New Users to Excel | |||
| Arithmetical Mode of Criteria in Multiple Non-Adjacent columns | Excel Worksheet Functions | |||
Linear Mode
