How do I Extract information before a sign "/" in a separate cell ?
How do I Extract information before a sign "/" in a separate cell ?
Please try this function
For 'before'
=LEFT(A1,FIND("/",A1)-1)
For 'after'
=SUBSTITUTE(RIGHT(SUBSTITUTE(A1,"/",REPT("!",LEN(A1))),LEN(A1)),"!","")
Please click 'Add reputation', if my answer helped you.
Try this:
=LEFT(A1,FIND("/",A1)-1)
Hope this helps.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks