Forum Discussion
Text to Column (changing delimiters)
I have a long string seperated (delimited) by tabs; but there are also commas and colons in it (that are NOT delimiters).
When I use my version of Excel I can change the delimiters to make it work; but my son uses a different version of Excel (cloud based?) and tells me there is no data button and no "text to column" box to change delimiters. He used Control+Shift+V do parse the data cells.
Is there a way to access the delimiter box on the cloud based version? (I recall from years ago one could put the "Data" tab on the options (as it was not there by default).
1 Reply
Hi John11
This could be bcz of your locale setting, pls check your son & your system locale setting.
if you could share the file along with desired results, that would helpful for us to guide you
Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel ExpertIf you find the above solution resolved your query don't forget mark as Official Answer.