Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. mtmanecho

    Excel - How do I remove characters from th left side of a string

    This works perfect =right(A151,len(A151)-6) Now that I look at it, it makes total sense but for the life of me I couldn't grasp it. Thank you
  2. mtmanecho

    Excel - How do I remove characters from th left side of a string

    Thanks I will try these you guys ROCK!!!
  3. mtmanecho

    Excel - How do I remove characters from th left side of a string

    I was able to get these two cells with =RIGHT($A$151,10) yet I am still stumped with a name field because I do not know how long the name is going to be when It gets pasted in. example: name: John Doe & name: John Dawson any ideas how to just strip off of the left?
  4. mtmanecho

    Excel - How do I remove characters from th left side of a string

    I am just digging into excel and found that it would be very helpful if I could chop so many characters off of a certain cell or cells example: "Date:" and "Request ID:" are static and unwanted Date: 11/30/2002 Request ID: BrKUq43D any ideas?

Part and Inventory Search

Back
Top