Formula To Remove Part Of Text Based On It's Position In A Sentence

[mydogjake]

Thanks in advance for any/all help with a newbie.

I'm searching for a method to extract all values after the 3rd space from the right... with the values posted to separate column -and finally, re-combining the extracted string with only the left values of the original string up to and including the last "/"

Description:

987654321 6 Snickersbars11/14/14/HD,X 1.50 4.40 7.50 ---> want string: 1.50 4.40 7.50 in separate column... finally
..want to rebuild original description with only the values up to (and including) the last "/" and the string just extracted.

Desired outcome:
987654321 6 Snickersbars11/14/14/ 1.50 4.40 7.50

I have a simple file if that helps?
Thanks greatly. Mike

[Rick Rothstein]

Duplicate post here...

Help extracting string - 3 spaces from end of description (http://www.mrexcel.com/forum/excel-questions/826421-help-extracting-string-3-spaces-end-description.html#post4031972)

[mydogjake]

Duplicate post here...

Help extracting string - 3 spaces from end of description (http://www.mrexcel.com/forum/excel-questions/826421-help-extracting-string-3-spaces-end-description.html#post4031972)


Thanks Rick but your post doesn't help?

I'm time crunched and tried two websites - hoping that more "bait in the water" would gain me a faster solution.
I didn't know that ExcelFox and MrExcel are somehow connected.


https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA (https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA)

[Rick Rothstein]

Thanks Rick but your post doesn't help?

I'm time crunched and tried two websites - hoping that more "bait in the water" would gain me a faster solution.
I didn't know that ExcelFox and MrExcel are somehow connected.
ExcelFox and MrExcel are not connected... my message wasn't meant to help you... it was meant to help other volunteers who might read your question. See here for why what you did is considered a problem...

http://www.excelfox.com/forum/f25/message-to-cross-posters-1172/

[mydogjake]

ExcelFox and MrExcel are not connected... my message wasn't meant to help you... it was meant to help other volunteers who might read your question. See here for why what you did is considered a problem...

http://www.excelfox.com/forum/f25/message-to-cross-posters-1172/


Ah. I understand.
I will graciously (and expeditiously) post links between posts so that others may benefit!
..hope I did not offend those who may offer assistance :peacesign:




https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA (https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA)