Changing order of the digits in a number in excel using VBA code

[aaa125]

I want to change the order of a string such as 32cd4f18 so that it gives an output of 23dcf481. So the string should be swapped in pairs. If someone could help me with a VBA code that would be very helpful.

 

[Rick Rothstein]

You did not say if you have just the one text string to process (as your post seems to indicate) or a column's worth of data to process. Here is a UDF (user defined function) that can be used for one or a somewhat small number of text strings (if you have a large list to process, a macro would probably be more efficient)...

Function ReversePairs(S As String) As String
  Dim X As Long
  For X = 1 To Len(S) Step 2
    ReversePairs = ReversePairs & StrReverse(Mid(S, X, 2))
  Next
End Function