Help Extracting data to columns

tylertownflorist

New Member
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
PO Number: S/O: Vergie Pittman Dillon
-------------------------------------
Account \$107.00
Account Name: Billdora Senior Care, LLC
Account Number: 100163
PO Number: S/O: Charlene Case
-------------------------------------
Account \$174.41
Account Name: Jones Trucking
Account Number: 100307
PO Number: S/O: Rev. Kenneth Rocko
-------------------------------------
Account \$96.30
Account Name: Silver Creek Baptist Church
Account Number: 100178
PO Number: S/O: Sandy Simmons
-------------------------------------

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.
can anyone help me with this . I would really appreciate it so much!

Replies
0
Views
475
Replies
1
Views
263
Replies
4
Views
463
Replies
0
Views
435
Replies
1
Views
298

1,219,914
Messages
6,150,936
Members
450,994
Latest member
MacOrch

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back