tylertownflorist
New Member
- Joined
- Sep 17, 2014
- Messages
- 2
Im having a problem getting information from a cell in an excel file that I export out of our POS system. Below is an example of a few cells and how they are formatted when I export. I need to get each one of these items into its own cell.
Column is H3 and I have separated each cell with a dash to show out it is formatted in the cell. Account $$$$.$$ is the amount of the invoice, Account Name: is the Account Name, Buyer is Who Purchased it, PO Number is the PO Number Given or if one was not provided we use who the order went to. I Don't know if this can be done, I only need the data not the label (example Only Need 100136 not Account Number: 100136, but each one needs to be extracted not just one of them. I hope I have explained this correctly. I have racked my brain on how to do this and can not figure it out. Text to Columns will not work because of the variable length of the information. Any help would be so greatly appreciated.
Each row following the 1st row of each cell has an indent of 8 spaces I could not get the spaces to show in my example.
Column is H3
-------------------------------------
Account $326.35
Account Name: Washington Funeral Home
Account Number: 100136
Buyer: Eric
PO Number: S/O: Vergie Pittman Dillon
-------------------------------------
Account $107.00
Account Name: Billdora Senior Care, LLC
Account Number: 100163
Buyer: Cindy
PO Number: S/O: Charlene Case
-------------------------------------
Account $174.41
Account Name: Jones Trucking
Account Number: 100307
Buyer: Brett Stogner (lady called for him)
PO Number: S/O: Rev. Kenneth Rocko
-------------------------------------
Account $96.30
Account Name: Silver Creek Baptist Church
Account Number: 100178
Buyer: Carol Garner
PO Number: S/O: Sandy Simmons
-------------------------------------
Thank you in advance!
Column is H3 and I have separated each cell with a dash to show out it is formatted in the cell. Account $$$$.$$ is the amount of the invoice, Account Name: is the Account Name, Buyer is Who Purchased it, PO Number is the PO Number Given or if one was not provided we use who the order went to. I Don't know if this can be done, I only need the data not the label (example Only Need 100136 not Account Number: 100136, but each one needs to be extracted not just one of them. I hope I have explained this correctly. I have racked my brain on how to do this and can not figure it out. Text to Columns will not work because of the variable length of the information. Any help would be so greatly appreciated.
Each row following the 1st row of each cell has an indent of 8 spaces I could not get the spaces to show in my example.
Column is H3
-------------------------------------
Account $326.35
Account Name: Washington Funeral Home
Account Number: 100136
Buyer: Eric
PO Number: S/O: Vergie Pittman Dillon
-------------------------------------
Account $107.00
Account Name: Billdora Senior Care, LLC
Account Number: 100163
Buyer: Cindy
PO Number: S/O: Charlene Case
-------------------------------------
Account $174.41
Account Name: Jones Trucking
Account Number: 100307
Buyer: Brett Stogner (lady called for him)
PO Number: S/O: Rev. Kenneth Rocko
-------------------------------------
Account $96.30
Account Name: Silver Creek Baptist Church
Account Number: 100178
Buyer: Carol Garner
PO Number: S/O: Sandy Simmons
-------------------------------------
Thank you in advance!
