LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 127
Default Extracting data

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Extracting Data for .Txt Files By Unique Field Data La Excel Discussion (Misc queries) 3 July 17th 06 01:30 PM
Extracting Data Aoife101 Excel Discussion (Misc queries) 2 June 30th 06 11:39 AM
Extracting data Gingit Excel Discussion (Misc queries) 2 June 14th 06 05:42 PM
Extracting data edmacd Excel Discussion (Misc queries) 2 September 30th 05 04:15 PM
Extracting data Al Excel Worksheet Functions 7 April 19th 05 04:38 PM


All times are GMT +1. The time now is 11:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"