I have a dropdown menu in a particular cell whose data always looks like this: 20/30, 400/600, 1000/1000 e.t.c I would like the number before the "/" to be fed into one cell and the numebr after the "/" fed into another cell.
Example: original cell D4 has value "500/1000" and I would like 500 to feed into M4 and 1000 to feed into N4.
I hope one of you gurus can help me with this. Thanks in advance for the help.
in M4:
=IF(D4="","",LEFT(D4,FIND("/",D4)-1))
in N4,
=IF(D4="","",MID(D4,FIND("/",D4)+1,10))
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Just what I needed! Thanks NBVC! Thanks a bunch!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks