Hi All
I recieved data from an interface but need to put in correct pattern
that 6x750MLx1 should read 1*6*750 ML
Hi All
I recieved data from an interface but need to put in correct pattern
that 6x750MLx1 should read 1*6*750 ML
Try
B2Formula:Please Login or Register to view this content.
Last edited by shukla.ankur281190; 05-30-2017 at 07:52 AM. Reason: Something missing
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
You can use this formula in B2:
=RIGHT(A2,LEN(A2)-FIND("X",A2,4))&"*"&SUBSTITUTE(SUBSTITUTE(LEFT(A2,FIND("X",A2,4)-1),"X","*"),"ML"," ML")
then copy down.
Hope this helps.
Pete
Pete & Shukla thank you for assistance
Worked as requested
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks