'Text to column' in excel retains last used settings -


'text column' feature in ms excel retains last used delimiter(except tab defualt setting) till close excel spreadsheet , reopen it.

wanted understand how can move tab delimiter after operation performed.

i don't think possible without vba. can text columns on single cell, changing settings tab only.


Comments