floggingmolly
Board Regular
- Joined
- Sep 14, 2019
- Messages
- 167
- Office Version
- 365
- Platform
- Windows
Hi everyone. I'm trying to do a formula that will extract data from the middle of a cell. For example I have data like this in cells:
Toms Roofing B016321 Z001623
There is a company name, Company ID, and Service Code. I need to be able to split these into 3 columns. Since the company name, company ID, and service code are not a set # of characters (ex. Company Code could be B0000000651 for one and maybe B00541 for another) I can't use the text to columns feature. If anyone can help with a formula I would appreciate it. I've tried several and can't get it to work correctly with all the rows on the worksheet.
Toms Roofing B016321 Z001623
There is a company name, Company ID, and Service Code. I need to be able to split these into 3 columns. Since the company name, company ID, and service code are not a set # of characters (ex. Company Code could be B0000000651 for one and maybe B00541 for another) I can't use the text to columns feature. If anyone can help with a formula I would appreciate it. I've tried several and can't get it to work correctly with all the rows on the worksheet.