Link to home
Create AccountLog in
Avatar of Fordraiders
FordraidersFlag for United States of America

asked on

extract data from first dash in cell

excel 2010 :
What I need:

=IF(ISERROR(FIND("-",B2)),B2,RIGHT(B2,FIND("-",B2)-1))

The following formula will work..but extracts after second   - (dash)

I have alphanumeric numbers like..

ape-234-qwe32

ape4-er44-564


I'm looking for
234-qwe32

er44-564

if only one dash exists...still extract data after first dash.

Thanks
fordraiders
ASKER CERTIFIED SOLUTION
Avatar of Phillip Burton
Phillip Burton

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Fordraiders

ASKER

thanks ! sorry for the delay