Thread: Function for all Characters after the :
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default Function for all Characters after the :
=RIGHT(B3,LEN(B3)-FIND(":",B3)-1)


" wrote:

I need a formuls that will take all of the Characters after a colon in
a cell.
I Have:
B3 = LastName : Jones
B4 = LastName : Anderson
I need:
R3 = Jones
R4 = Anderson

Thanks in advance for the help.
Mike3108


Reply With QuoteReply With Quote