Thread: Text function
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
nc nc is offline
external usenet poster
 
Posts: 119
Default Text function

Dear Stefi

What sbout if I just want to reverse a text in a cell.

Thanks.

NC

"Stefi" wrote:

Only VBA has such a function (InStrRev). You can create an UDF like this:

Public Function FindRev(StrtoSearch As String, StrSearchedFor As String) As
Long
FindRev = 0
On Error Resume Next
FindRev = InStrRev(StrtoSearch, StrSearchedFor)
End Function

Regards,
Stefi


€žnc€ ezt Ã*rta:

Is there a function in Excel 2003 that is like "Search"/"Find", but start
from the right?

Thanks