You can try this: https://superuser.com/questions/121618/any-excel-function-that-will-reverse-a-stringThe second answer looks better than the first.

Does anyone know a formula to reverse the order of text within a cell?EG: the text TCRVO is אברהם in hebrew but I have it written in excel as OVRCT so is there any way to reverse the order?TIA

=IF(LEN(A1)<1,"",MID(A1,LEN(A1),1))&IF(LEN(A1)<2,"",MID(A1,LEN(A1)-1,1))&IF(LEN(A1)<3,"",MID(A1,LEN(A1)-2,1))&IF(LEN(A1)<4,"",MID(A1,LEN(A1)-3,1))&IF(LEN(A1)<5,"",MID(A1,LEN(A1)-4,1))&IF(LEN(A1)<6,"",MID(A1,LEN(A1)-5,1))&IF(LEN(A1)<7,"",MID(A1,LEN(A1)-6,1))&IF(LEN(A1)<8,"",MID(A1,LEN(A1)-7,1))&IF(LEN(A1)<9,"",MID(A1,LEN(A1)-8,1))&IF(LEN(A1)<10,"",MID(A1,LEN(A1)-9,1))&IF(LEN(A1)<11,"",MID(A1,LEN(A1)-10,1))&IF(LEN(A1)<12,"",MID(A1,LEN(A1)-11,1))&IF(LEN(A1)<13,"",MID(A1,LEN(A1)-12,1))&IF(LEN(A1)<14,"",MID(A1,LEN(A1)-13,1))&IF(LEN(A1)<15,"",MID(A1,LEN(A1)-14,1))&IF(LEN(A1)<16,"",MID(A1,LEN(A1)-15,1))&IF(LEN(A1)<17,"",MID(A1,LEN(A1)-16,1))&IF(LEN(A1)<18,"",MID(A1,LEN(A1)-17,1))&IF(LEN(A1)<19,"",MID(A1,LEN(A1)-18,1))&IF(LEN(A1)<20,"",MID(A1,LEN(A1)-19,1))&IF(LEN(A1)<21,"",MID(A1,LEN(A1)-20,1))&IF(LEN(A1)<22,"",MID(A1,LEN(A1)-21,1))&IF(LEN(A1)<23,"",MID(A1,LEN(A1)-22,1))&IF(LEN(A1)<24,"",MID(A1,LEN(A1)-23,1))&IF(LEN(A1)<25,"",MID(A1,LEN(A1)-24,1))&IF(LEN(A1)<26,"",MID(A1,LEN(A1)-25,1))

Thanks, I found that as well just now but over here: https://www.extendoffice.com/documents/excel/1146-excel-reverse-string-word-order.html#a1So far so good.

I would like to move every second row to column B and every 3rd row to column C.Anyway to do do it ?

i am trying to add up hours using =TEXT(G27-F27, "h") is it possible to add a few times slot like 8-10 AM 2-4PM it gives me a error when i try=TEXT(G27-F27,I27-H27, "h")or things similar TIA

=TEXT(G27-F27, "h")+TEXT(I27-H27, "h")

How aboutCode: [Select]=TEXT(G27-F27, "h")+TEXT(I27-H27, "h")

Thanks that was simple.

=TEXT(G27-F27+I27-H27, "h")

No need to double up the formula (I assume, haven't tested yet):Code: [Select]=TEXT(G27-F27+I27-H27, "h")