Need a formula to reverse text

Try This:

Use Text to columns with the backslash as the delimiter, then use Concatenate in another column to rejoin the cells in reverse order.

That's a tough one with a formula! How about a user-defined function? Paste the following code into a module in your workbook (if you don't know how to do this, let me know and I will explain). Nothing a little recursion can't solve!

Hope this helps,

Russell

Option Explicit 



Public Function ReverseTrip(rng As Range) As String 
    
'Application.Volatile
If rng.Cells.Count > 1 Then 
        ReverseTrip = "N/A" 
Exit Function 
Else 
        ReverseTrip = ReverseSlash(Trim(rng.Text)) 
End If 
End Function 



Private Function ReverseSlash(strText As String) As String 
    Dim intSlash As Integer 
Dim strTemp As String 

    intSlash = InStr(strText, "/") 
If intSlash > 0 Then 
        strTemp = Left(strText, intSlash - 1) 
        ReverseSlash = ReverseSlash(Right(strText, Len(strText) - intSlash)) & "/" & strTemp 
Else 
        strTemp = strText 
        ReverseSlash = strText 
End If 
       
End Function 

Pls let me know if you need further help...

Feel free to email me or post a message... intSlash = InStr(strText, "/") If intSlash > 0 Then strTemp = Left(strText, intSlash - 1) ReverseSlash = ReverseSlash(Right(strText, Len(strText) - intSlash)) & "/" & strTemp strTemp = strText ReverseSlash = strText End If