I think this is one of those yes or no questions.
Is there an excel function that will take the data in a cell and reverse it for me?
For example, if cell A1 contains the text 'AB CD EF', is there a function that would enable me to output 'FE DC BA' in cell B1?
I did look at trying to cobble something together with the MID and RIGHT commands but I couldn't make it work.
I'm afraid my knowledge only extends to ordinary formulas so array formula solutions or VB solutions wouldn't be of any use to me.
Thanks,
Andrew.
Is there an excel function that will take the data in a cell and reverse it for me?
For example, if cell A1 contains the text 'AB CD EF', is there a function that would enable me to output 'FE DC BA' in cell B1?
I did look at trying to cobble something together with the MID and RIGHT commands but I couldn't make it work.
I'm afraid my knowledge only extends to ordinary formulas so array formula solutions or VB solutions wouldn't be of any use to me.
Thanks,
Andrew.