Hi,
I have a cell with 33a21 / 52:334. Is there a formula to flip the contents of the cell using the "/" as a delimiter? So the output would be 52:334 / 33a21?
Thanks.
Hi,
I have a cell with 33a21 / 52:334. Is there a formula to flip the contents of the cell using the "/" as a delimiter? So the output would be 52:334 / 33a21?
Thanks.
Last edited by Warder; 04-23-2019 at 12:42 PM. Reason: clarity
1] A1 : 33a21 / 52:334
2] B1 formula :
=MID(A1&" / "&A1,FIND("/",A1)+2,LEN(A1))
Regards
Bosco
Thanks so much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks