Thread: How to remove characters in a cell that precede a specific hyphen
View Single Post
  #12   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
  
Posts: 9,221
Default How to remove characters in a cell that precede a specific hyp
You just need to remove the "+0" from the earlier,
viz use in B1, copied down:
=MID(A1,SEARCH("-",A1,SEARCH("-",A1)+1)+1,99)
(All extracts in col B will be in text)

Anyway, I see you have since received an answer you like
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"brantty" wrote in message
...
Max,

This works for most of my data but I have some data that has alpha
characters in them where this formula fails. Can you or FSt1 offer an
adaptation to this formula that allows for alpha characters?

Here's a few more examples

ABA-12345-12345
ABA-C12345-C12345
ABC-18L123-18L123
ABC-Q456789-Q456789


Reply With QuoteReply With Quote