Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have some data that came in a text files. It is hard to split the fields
because there is no even breaking point, not comma delimited or anything. The text contains company names and bid number. The bid number always start with B0?-???. I would like separate the company name and the bid number in two columns. Sample : A & F INDUSTRIES B06-171 AW Breakdown: A & F INDUSTRIES (company name ) B06-171 AW is the bid number. Sample: ADMIRALITE MARINE & STRUCTURE B07-118 SL Breakdown: ADMIRALITE MARINE & STRUCTURE (company name) B07-118 SL (bid number). How can I extract or separte the data is in one column. I need it in 2 columns. Right now the file is in .txt. Thanks for any Help |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Extracting Data for .Txt Files By Unique Field Data | Excel Discussion (Misc queries) | |||
Extracting Data | Excel Discussion (Misc queries) | |||
Extracting data | Excel Discussion (Misc queries) | |||
Extracting data | Excel Discussion (Misc queries) | |||
Extracting data | Excel Worksheet Functions |