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?

to get FA282A use:

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

to get HEW use:

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

HTH

" 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?

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

" 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?

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

" 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?

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" wrote:

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

" 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?

Toppers, thanks so much! It worked perfectly.

K~

Toppers wrote:
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" wrote:

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

" 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?

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



" 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?