Forum Discussion
Split data from one column without using text to column
Hi, I have some data(Invoice Nos) in a col A in a text format separated with"/", i want to split the same with using a formula (NOT TEXT TO COLUMN) coz if new data is added I'll need to go throug...
I have data
For Column 2, the Text to Column "split" , split the dash from the two elements, but the 2nd split then overides the"cookies shipped column 3"..... I want to delimit and split, but not lose column next to me 😞
Order IDCustomer IDCookies ShippedRevenueCostOrder DateShip DateOrder Status
| 413383 | 152689 - YT Restaurants | 936 | 4680 | 2340 | 12/31/17 | 1/5/18 | Shipped |
| 751142 | 985245 - Quick Bite Convenience Stores | 987 | 4935 | 2467.5 | 12/31/17 | 1/4/18 | Shipped |