**Question description:**

*This user has given permission to use the problem statement for this blog.*

Trying to write a formula to pull all values from a cell that are LEFT of a hyphen "-", or all values if no hyphen

Solved by F. L. in 54 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
02/02/2018 - 03:05

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

Excelchat Expert
02/02/2018 - 03:06

done

User
02/02/2018 - 03:07

so oddly enough...I'm putting it in my formuala...it doesn't error out, but almonst converts it to text?

Excelchat Expert
02/02/2018 - 03:07

hello

Excelchat Expert
02/02/2018 - 03:08

is it solved?

User
02/02/2018 - 03:08

no

User
02/02/2018 - 03:09

i'ved pasted the data i'm working with

User
02/02/2018 - 03:12

it's erroring out now

Excelchat Expert
02/02/2018 - 03:12

try this

Excelchat Expert
02/02/2018 - 03:12

=REPLACE(A2,1,FIND("-",A2),"")

User
02/02/2018 - 03:14

k

User
02/02/2018 - 03:21

the session says we r timing out...you are still working on it right?

Excelchat Expert
02/02/2018 - 03:21

yes i think i am done

User
02/02/2018 - 03:21

k

Excelchat Expert
02/02/2018 - 03:22

[Uploaded an Excel file]

User
02/02/2018 - 03:23

the value is pulling right of the hyphen...need left

User
02/02/2018 - 03:23

rows 11, 13, 14, and 16 in what's showing is correct

User
02/02/2018 - 03:24

we just need an 'IF" statement on what it should do if it can't fine the "-"...then it should just pull the entire cell

Excelchat Expert
02/02/2018 - 03:24

ohk

Excelchat Expert
02/02/2018 - 03:37

[Uploaded an Excel file]

Excelchat Expert
02/02/2018 - 03:37

done

Excelchat Expert
02/02/2018 - 03:37

please rate me at the end of session

Excelchat Expert
02/02/2018 - 03:38

please end the session

User
02/02/2018 - 03:44

it's just pulling the full field value...not what's left of the hyphen

Excelchat Expert
02/02/2018 - 03:45

ohh sorry

Excelchat Expert
02/02/2018 - 03:52

=LEFT(A2,IFERROR(FIND("-",A2),999)-1)

Excelchat Expert
02/02/2018 - 03:52

[Uploaded an Excel file]

Excelchat Expert
02/02/2018 - 03:54

done

User
02/02/2018 - 03:55

it's returning a 5 digit # in my doc...do I need to reformat the cell or something?

Excelchat Expert
02/02/2018 - 03:55

yes

Excelchat Expert
02/02/2018 - 03:55

but my formula is working 100%

Excelchat Expert
02/02/2018 - 03:55

returning output as you desire?

User
02/02/2018 - 03:56

i'm still getting numbers...

Excelchat Expert
02/02/2018 - 03:56

what number?

User
02/02/2018 - 03:57

I just figured it out...wrong cell reference

User
02/02/2018 - 03:57

yay!!!!

User
02/02/2018 - 03:57

finished!!!!

User
02/02/2018 - 03:57

amazing!!!

User
02/02/2018 - 03:57

thank you!!!

Excelchat Expert
02/02/2018 - 03:57

yes please rate me before ending session

Excelchat Expert
02/02/2018 - 03:57

your most welcome:)

User
02/02/2018 - 03:57

where is the rating button

Excelchat Expert
02/02/2018 - 03:58

after ending session

User
02/02/2018 - 03:58

k

Excelchat Expert
02/02/2018 - 03:58

you will see

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*