column value split to different columns

[Keerthana_Adamana]

Hi, 

I would like To split the column values like "MTW" into separate columns with individual values using the Text to Columns tool. Please do 

[binuacs]

@Keerthana_Adamana one way of doing this

[Keerthana_Adamana]

@binuacs That was brilliant! It worked. If there is "MTh" i.e., Th should come in one column it should not split. Can you please solve this ?

[binuacs · Accepted solution]

@Keerthana_Adamana Try