Forum Discussion
Text After Delimiter
Dear Experts, Could you please help in below Query:- In Attached Excel, I want my data like in Column "B" only the Text after 4 spaces(Item xx), then in Column "C" the text aft...
Thanks Hans, is there any other smaller formula we may have?
Using Patrick2788 's idea:
=IF((LEFT($A132,4*COLUMN()-4)=REPT(" ",4*COLUMN()-4))*(MID($A132,4*COLUMN()-3,1)<>" "),TRIM($A132),"")