Home / Discussions

Report Offensive Message

RE: Using Excel's Find and Mid to extract a substring
Numbers to the Right: =RIGHT(A2,((LEN(A2))-(FIND("/",A2))))
Numbers to the Left: =LEFT(A2,((FIND("/",A2))-1))

Where A2 is your source string (like 123/456)
Posted by robert.eubank@...
Updated - 14th Jul 2011