LinkBack URL
About LinkBacks
Try this in C69:
=LEFT(SUBSTITUTE(C68,"/",REPT(" ",100)),100)+MID(SUBSTITUTE(C68,"/",REPT(" ",100)),100,100)+RIGHT(SUBSTITUTE(C68,"/",REPT(" ",100)),100)
Hope this help.
Try this in C69:
=LEFT(SUBSTITUTE(C68,"/",REPT(" ",100)),100)+MID(SUBSTITUTE(C68,"/",REPT(" ",100)),100,100)+RIGHT(SUBSTITUTE(C68,"/",REPT(" ",100)),100)
Hope this help.
Quang PT
This works perfectly when I have 3 numbers in a cell. Sometimes I have 4 or 2 numbers in a cell. Is there a way the formula would automatically adjust to that?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks