Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 4 of 4

Thread: Remove all hyphens from a cell

  1. #1
    Join Date
    24th August 2006
    Posts
    2

    Remove all hyphens from a cell

    First post, interesting Title requirements you have here

    I am trying to take a list of part numbers that have an undefined number of hyphens in the part number, and remove the hyphens in order to use the VLOOKUP function.

    Example part numbers are AA34-55A3-L, 444342-02, etc.

    I tried searching for threads that helped on this subject but they all involved VBA, which I do not know how to use with Excel. I took VB senior year of high school and C for a semester in college, so I recognize the commands, but I have no idea how it's implemented.

    Is there a [relatively simple] way to do this with Excel functions? If not, how would I implement this using VBA? I am currently using the 2003 edition.

    Thanks!

    B

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    10th February 2003
    Location
    Palm Beach, Florida
    Posts
    1,590

    Re: Remove all hyphens from a cell

    First just try just selecting the whole sheet and do a find/replace on "-" with "".

    If you really want the macro, just record the steps. It's such a simple manual process it really doesn't warrant a macro... unless it's an embedded step in a larger macro.
    Sub All_Macros(Optional control As Variant)

  3. #3
    Join Date
    24th January 2003
    Location
    Australia
    Posts
    31,716

  4. #4
    Join Date
    24th August 2006
    Posts
    2

    Re: Remove all hyphens from a cell

    Thanks for the help, I got it!

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Find Text Between Characters And Remove Hyphens
    By meowsd in forum EXCEL HELP
    Replies: 5
    Last Post: October 20th, 2013, 19:33
  2. Sort Numbers Containing Hyphens
    By cnl in forum EXCEL HELP
    Replies: 4
    Last Post: November 21st, 2006, 17:49
  3. Formatting alpha/numeric part numbers with hyphens
    By steelmover in forum EXCEL HELP
    Replies: 5
    Last Post: September 28th, 2005, 05:57

Bookmarks

Posting Permissions

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