Hi,
Property-and-equipment
I need to extract the text from the second (-), i am unable to extract the text.
=LEFT(D10,FIND("-",D10)-1)
Result : Property
Expected Result : Property-and
Hi,
Property-and-equipment
I need to extract the text from the second (-), i am unable to extract the text.
=LEFT(D10,FIND("-",D10)-1)
Result : Property
Expected Result : Property-and
=left(d10,find("^",substitute(d10,"-","^",2))-1)
One way:Formula:Please Login or Register to view this content.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Sorry, fro D10:Formula:Please Login or Register to view this content.
Try this one
=TRIM(LEFT(SUBSTITUTE(D10,"-",REPT(" ",25),2),25))
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
Hi,
Thanks for All,
All the three functions worked fine.....
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks