Thread: If 5th character="-" delete everything to the left otherwise do no
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John C[_2_] John C[_2_] is offline
external usenet poster
  
Posts: 1,358
Default If 5th character="-" delete everything to the left otherwise do no
You really should put your main question in the white box, not in the header.

=IF(LEN(A1)<5,A1,IF(MID(A1,5,1)="-",RIGHT(A1,LEN(A1)-5),A1))
--
** John C **


"Mike R." wrote:

Hi -
I can't seem to figure this out, I bet it is pretty easy. Can anyone assist?

The text is in A1.

Thanks,
Mike
Reply With QuoteReply With Quote