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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks