Hi,
Could you please help me with finding the best way to extract the data from the 'data to be extracted' column and dividing it up into three columns like below.
There will be multiple cells but they all follow the same format.
Thanks very much.
Could you please help me with finding the best way to extract the data from the 'data to be extracted' column and dividing it up into three columns like below.
There will be multiple cells but they all follow the same format.
Data to be Extracted | Extract 1 | Extract 2 | Extract 3 |
22 Jan ROYAL MAIL GROUP LTD CHESTERFIELD GBR 4.54 | 22-Jan | ROYAL MAIL GROUP LTD CHESTERFIELD | £4.54 |
Thanks very much.