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.

`from the third space to the next number`

always apply? – Scott Craner Sep 9 '19 at 20:24