Results 1 to 5 of 5

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

  1. #1
    Junior Member
    Join Date
    Dec 2014
    Posts
    3
    Rep Power
    0

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

    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

  2. #2

  3. #3
    Junior Member
    Join Date
    Dec 2014
    Posts
    3
    Rep Power
    0
    Quote Originally Posted by Rick Rothstein View Post

    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
    Last edited by DocAElstein; 06-11-2023 at 01:21 PM.

  4. #4
    Forum Guru Rick Rothstein's Avatar
    Join Date
    Feb 2012
    Posts
    662
    Rep Power
    13
    Quote Originally Posted by mydogjake View Post
    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/me...-posters-1172/

  5. #5
    Junior Member
    Join Date
    Dec 2014
    Posts
    3
    Rep Power
    0
    Quote Originally Posted by Rick Rothstein View Post
    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/me...-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




    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    Last edited by DocAElstein; 06-11-2023 at 01:21 PM.

Similar Threads

  1. Replies: 3
    Last Post: 08-15-2013, 01:00 AM
  2. Replies: 3
    Last Post: 06-01-2013, 11:31 AM
  3. Remove Special Characters From Text Or Remove Numbers From Text
    By Excel Fox in forum Excel and VBA Tips and Tricks
    Replies: 5
    Last Post: 05-31-2013, 04:43 PM
  4. Remove Numerics From Text
    By VIMAL CHALISSERY in forum Excel Help
    Replies: 2
    Last Post: 04-12-2012, 08:43 PM
  5. Remove Zero / Zeroes From Alphanumeric Text
    By Excel Fox in forum Excel and VBA Tips and Tricks
    Replies: 0
    Last Post: 04-04-2011, 01:16 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •