andy.ujo

Q: Apple - Numbers - Split text or reference words in a cell

I have daily orders that I would like to able to enter into a cell that automatically gets split into a table.

 

Example:

Order# | Method of Delivery | Line number | Account | Reference

 

Would be entered into cell as:

51698 Driver 3 A2514D K-91

12345 Ship 5 D5215R K-25

 

Desired Result:

 

OrderMethod Of DeliveryLine #AccountReference
51698driver3A2514DK-91
12345Ship5D5215RK-25

 

Also,

I would like to be able to filter the method of delivery (or at least sort it by Method of Delivery)

 

Any help is appreciated

iWork for iCloud

Posted on Jan 6, 2015 5:35 PM