Re: How do I separate a hyphenated word in Excel?

Tech-Archive recommends: Fix windows errors by optimizing your registry

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

Toppers wrote:
to get FA282A use:

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

to get HEW use:

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

HTH

"tone_1998@xxxxxxxxx" wrote:

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?

.

Relevant Pages