Get characters on left of specified character in Excel
Thanks a lot. It really helped.
"Roger Govier" wrote:
Hi
If you are talking about Left of the first hyphen, then
=LEFT(A1,FIND("-",A1)-1)
If you are talking about left of the second hyphen then
=LEFT(A1,FIND("^",SUBSTITUTE(A1,"-","^",2))-1)
If you are talking about between the 2 hyphens then
=MID(A1,FIND("-",A1)+2,FIND("^",SUBSTITUTE(A1,"-","^",2))-FIND("-",A1)-2)
--
Regards
Roger Govier
"Murugan" wrote in message
...
In an Excel column I am having values like
A1 - abcd - abcdedfg
A2 - abc - zyxwvu
A3 - ab - mnopq
I need a formula to get all characters left of the hypen for each
value in
another column. Hypen may occur in any position (except first).
Any pointers? Thanks in Advance
|