Forum Discussion
Split data from one column without using text to column
Hi, I have some data(Invoice Nos) in a col A in a text format separated with"/", i want to split the same with using a formula (NOT TEXT TO COLUMN) coz if new data is added I'll need to go throug...
Another formula is explained here https://exceljet.net/formula/split-text-with-delimiter
Looks like
=TRIM(MID(SUBSTITUTE($B4,"/",REPT(" ",LEN($B4))),(L$3-1)*LEN($B4)+1,LEN($B4)))
and attached