Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I need to convert a .txt file which has data without a commas.
00120* ROASTED RED PEPPER SPREAD RETAIL 44.590 CS 02951*GORDAL OLIVES UNPITTED 2/5 LB 59.910 CS The first 5 characters represent the product number and the text followed by until the space is the Product description, then Pack size, Price and Unit of Measure. Seeking from the experts the best way to convert this data to columns without much hassle. Thanks. Krish |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Convert text to columns | Excel Discussion (Misc queries) | |||
convert text to columns | Excel Discussion (Misc queries) | |||
How do I convert from text to columns automatically on import? | Excel Discussion (Misc queries) | |||
How do I convert text to columns when there is a carriage return? | Excel Worksheet Functions | |||
convert text labels to excel columns | New Users to Excel |