Thread: Trim characters
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
OssieMac OssieMac is offline
external usenet poster
 
Posts: 2,510
Default Trim characters

Hi Ronbo,

Do I interpret your question correctly then assuming the string is in A1 try
the following:-

=MID(A1,FIND("- ",A1,1)+2,255)

--
Regards,

OssieMac


"Ronbo" wrote:

I have looked and tried different formulas on the web site but I am not
getting what I am looking for. All I need is all characters after "- ".
It's got to be simple but I am not finding it.

Any help is appreciated.

Ronbo