L
Legacy 5232
Guest
I have 6 characters in a cell. The first 3 characters are 1 set and the next 3 characters are the 2nd set.
So basically, in cell A1, I may have characters "ABCDEF"
ABC = Set 1
DEF = Set 2
What formula could I use to invert these characters so that set 2 appears first then set 1, so it reads "DEFABC"?
Thanks
So basically, in cell A1, I may have characters "ABCDEF"
ABC = Set 1
DEF = Set 2
What formula could I use to invert these characters so that set 2 appears first then set 1, so it reads "DEFABC"?
Thanks