Script/Macro for detailed Text-To-Columns related issue?

Hi -

your data file has double space (" "), so you can use that in the formula in Column C;

=IFERROR(TRIM(MID(B2,SEARCH("  ",B2)+2,LEN(B2))),"")

event