Copy all text to the left of the hyphen

[Sean15]

Hi:

I have data in column D (see example below)

XXXXX - yyyyyy
ZZZ - ccccc
DDDDDDDDD - ddddd

I want to copy all text to the left of the hyphen to column E.

Could you help me.

 

[Domski]

Hi,

Try: =LEFT(D1,SEARCH("-",D1)-2)

Dom

 

[Jonmo1]

Try this...

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

Hope that helps.

 

[Cbrine]

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

HTH
Cal

 

[Sean15]

Domski/jonmo1/Cbrine:

Thanks.

Now that I have copied the data into column E, I have duplication. Would it be possible to copy all data to the right of the hyphen?

 

[Jonmo1]

Do you just want to seperate the data so you have 2 columns, 1 with the data to the left of the hyphen, and one with the data to the right?
I.E..

Start with

A1 = XXXXX - yyyyyy

End up with

A1 = XXXXX
B1 = yyyyy

??

Try Data - Text to Columns
Select Deliminated
Check Other and enter a hyphen

 

[Sean15]

jonmo1

Perfect solution, thank you.


Sean