I have a cell that contains a series as such:
3215314 01/01/1984 43 RASPBERRY PI CHEESE 10 COMPUTER PART 10 14 OZ 26.70 0
I need to isolate each part in a cell but I cannot use text to columns because it would put RASPBERRY PI CHEESE in 3 different cells and there are millions of cells.
Assuming the text I need is in cell A4, then I can find the first character (R) using the following formula:
=FIND(" ",A4,FIND(" ",A4,FIND(" ",A4)+1)+2)
I can then write to a cell using the MID function as such:
=MID(A4,FIND(" ",A4,FIND(" ",A4,FIND(" ",A4)+1)+2)+1,MY PROBLEM IS HERE)
I do not know how to find the number of characters to write RASPBERRY PI CHEESE in one cell. Thanks in advance.