Thread: If 5th character="-" delete everything to the left otherwise do no
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike R. Mike R. is offline
external usenet poster
  
Posts: 59
Default If 5th character="-" delete everything to the left otherwise do no
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