Forum Discussion
To inverse the words
I want write inversely the words in the same cell. For example; ( Washington-Paris-Ankara-Madrid) inversely>>(Madrid-Ankara-Paris-Washington) Thank you
A quick and dirty solution could be: use "text to columns" and as a delimiter [Others: "-"]. the formula CONCATENATE() helps you to rearrange the data. Maybe that helps. Best, Oliver