Thanks!! this works awesome!!!

"Gary''s Student" wrote:

Try this one line UDF:

Function reverse(r As Range) As String
reverse = StrReverse(r.Value)
End Function

--
Gary''s Student - gsnu200753


"karen" wrote:

I looking to take a column of part numbers (mixed with text and numerals) and
transpose the character position from left-to-right - changing it to
right-to-left. An example would be 5YA124 would change to read 421AY5