Hi All,
Hoping someone can help me here. I am looking to pull all the data from a cell before the "-" in the cell, however, if the cell does not have a "-" in it, then I want to pull the first word from that cell instead. Attached is an example. I figured out how to pull the data before the "-", I just can't seem to figure out how to add the part about if there is no dash, to pull the first word from the cell instead. My formula is in column R and is referencing column S.
Thanks,
Tom
Are the formats of the "Reasons" known or can these show up as anything?
LIke this?
=IF(ISNUMBER(SEARCH("-",S2)),LEFT(S2,FIND("-",S2)-1),LEFT(S2,1))
Teach me Excel VBA
Formula:
Please Login or Register to view this content.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Enter in R2 and copy down
Formula:Please Login or Register to view this content.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
This is perfect. Thank you so much.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks