How do I separate a hyphenated word in Excel?

[Guest]

I have a large file of 2000 lines and I would like to make 2 columns from 1.
For example:

COLUMN A

HEW-FA282A

I would like to remove the HEW- and insert it into another (new) column and
have the original column just read FA282A. Since the word is hyphenated I
have been unable to find the appropriate formula. Can anyone help me?

 

[Guest]

to get FA282A use:

=RIGHT(A1,LEN(A1)-FIND("-",A1,1))

to get HEW use:

=LEFT(A1,FIND("-",A1,1)-1)

HTH

 

[Guest]

Make sure column B is empty, then Highlight column A and do Data >
TextToColumns > Delimited > Next > Other > type the hyphen in the little
square next to Other > Next > Finish

Vaya con Dios,
Chuck, CABGx3

 

[FurRelKT]

This really helped me too,thanks, another question though, what if i
had 2 hyphens and needed the middle too?
for example: 01DEV-XXX-thisandthat
How do i get the 'inbetween' ?
Thanks for any help!

Keri

 

[FurRelKT]

This really helped me too,thanks, another question though, what if i
had 2 hyphens and needed the middle too?
for example: 01DEV-XXX-thisandthat
How do i get the 'inbetween' ?
Thanks for any help!

Keri

 

[Guest]

For the middle use:

=MID(A1,FIND("-",A1,1)+1,FIND("-",SUBSTITUTE(A1,"-","/",1),1)-FIND("-",A1,1)-1)

For the right use:

=RIGHT(A1,LEN(A1)-FIND("/",SUBSTITUTE(A1,"-","/",2),1))

HTH

 

[FurRelKT]

Toppers, thanks so much! It worked perfectly.

K~

For the middle use:

=MID(A1,FIND("-",A1,1)+1,FIND("-",SUBSTITUTE(A1,"-","/",1),1)-FIND("-",A1,1)-1)

For the right use:

=RIGHT(A1,LEN(A1)-FIND("/",SUBSTITUTE(A1,"-","/",2),1))

HTH