REVERSE

Returns the contents of a cell with all the characters reversed.

'sCellContents - The number or text you want to reverse.

Public Function REVERSE(ByVal sCellContents As String) As String

   If Application.WorksheetFunction.IsNonText(sCellContents) = True Then
      REVERSE = VBA.CVErr(xlCVError.xlErrNA)
   Else
      REVERSE = VBA.StrReverse(sCellContents)
   End If

End Function

If the argument is not a number or a text string, then #N/A is returned.
This function will not work in Excel 97 because the VBA function StrReverse does not exist.

=REVERSE(REVRESE()) = ??


© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited TopPrevNext