Thread: If 5th character="-" delete everything to the left otherwise do no
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
  
Posts: 3,346
Default If 5th character="-" delete everything to the left otherwise do no
Hi,

Try

=MID(A1,IF(MID(A1,5,1)="-",6,1),99)

Cheers,
Shane Devenshire

"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