Split data by delimiters but by formula (not Text to Columns)

Hi All,

I need to split data based on a delimiter but can't use text to columns because the columns adjacent to the complete data are already utilised. What formula do I use?

FYI the data looks like this:

12/34/567890/12

The delimiter of course being '/'

Thanks in advance.

Where is the result to go? One (or more columns) ?

It cannot be in the same cell (unless you use VBA)

Hi John (again!)

The original data is in column K. The new data needs to go into N, O, P & Q.

That is to say, the data before the first de-limiter should be shown in column N, the data between the first and second delimiter goes into column O and so on.

In N2

=TRIM(MID(SUBSTITUTE($K2,"/",REPT(" ",99)),(COLUMNS($A:A)-1)*99+1,99))

copy across to Q

You can use Text2Columns, set delimiter (in Delimiters: Other) "/", Next, Select destination cell (in this case can be N2) , Finish