Hi,
I have a column with descriptions (product type, color, size) on column A and I need to split it into 3 columns.
The problem is I cannot do this with Text to Data, as all info is split by "space" and there are 1-3 words for each criteria.
I was able to Flash Fill the first and last values (product type & size).
Now I would need a formula/VBA that extracts each of these details from the cells with full info, leaving just the color in the cell.
Or any other solution
If anyone is available to help, it would be very much appreciated.
Thanks,
xx
I have a column with descriptions (product type, color, size) on column A and I need to split it into 3 columns.
The problem is I cannot do this with Text to Data, as all info is split by "space" and there are 1-3 words for each criteria.
I was able to Flash Fill the first and last values (product type & size).
Now I would need a formula/VBA that extracts each of these details from the cells with full info, leaving just the color in the cell.
Or any other solution
If anyone is available to help, it would be very much appreciated.
Thanks,
xx