LinkBack URL
About LinkBacks
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. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
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
It was a typo - now corrected - thanks!Originally Posted by mangesh.mehendale
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
Is this because the data you are trying it on is in a different format to that which you provided in your first post?
mangesh your works , thank you very much
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks