KD-0219 GIRLS EVENING WITH BCK STRP #1350
KD-0247 (X11368) GIRL SPORT VELCRO M/MOUSE RS #2950
I have this on A1 and A2
Expected results
KD-0219 #1350
KD-0247 #2950
This mean delete after thing before sign leaving the first word
KD-0219 GIRLS EVENING WITH BCK STRP #1350
KD-0247 (X11368) GIRL SPORT VELCRO M/MOUSE RS #2950
I have this on A1 and A2
Expected results
KD-0219 #1350
KD-0247 #2950
This mean delete after thing before sign leaving the first word
If the text is in A1:
=LEFT(A1,8)&RIGHT(A1,LEN(A1)-FIND("#",A1)+1)
This assumes that the opening code will always be the same length.
Last edited by AliGW; 10-26-2015 at 06:32 AM.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Formula:Please Login or Register to view this content.
will work for any string
Last edited by mangesh.mehendale; 10-26-2015 at 06:19 AM.
Don`t care, take care...
Regards,
Mangesh
Tried not works , did it work your side
Yes both are working to my end..
see there is little change in Ali`s formula its not F8 (which will work only if len of "KD-0219" is 7) and mine will work for any string
Formula:Please Login or Register to view this content.
see attached file
mangesh your works , thank you very much
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks