Unconcatenate Formula

[mt]

I appreciate any help anyone would have with a formula to unconcatenate a text string. I have a concatenated text string in Column A. I want to separte the text into 4 columns in Column B, C,D, E. The each segment of the string is separated by an underscore "_". I.e. Bath Tile_Group Standard_Bathroom # 2_ 501. Thanks for the help. Mike

 

[VoG]

Try Data > Text to Columns, Delimited with _ as the delimiter.