Hello,

I have some text in cells formatted as

LLLLL, F RRR

And i was wondering if anyone had a macro that could rearrange it as so

RRR LLLLL
(deleting the F and , )

and the cells are arranged all over the sheet as a pyramid type shape, thanks in advance for the help !