iSixSigma

Convert Phone Number w/ Special Characters to Minitab or Excel?

Six Sigma – iSixSigma Forums General Forums Tools & Templates Convert Phone Number w/ Special Characters to Minitab or Excel?

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #53873

    McNicholl
    Participant

    I have 2 columns of phone numbers. One column is purely numerical, e.g. 441235832566, and the other is in the following format +44 (01636) 613462 (Country code prefixed with +, area code within brackets, then number). I want to compare the 2 columns to find matches but do not know how to change the column with the format +44 (01636) 613462 into the purely numerical format of 441636613462. So I need to remove the leading + the spaces the brackets and the 0 that preceeds the arear number. I can work with the data in either Minitab, Excel or MS Access. There are over 1000 numbers in each column.

    Yours hopefully,

    Colin

    0
    #191728

    Robert Ballard
    Participant

    Piggy backing off of Eric’s response, once you have reformatted the column you can use Excel’s vlookup function to find matches. You can also use Minitab using the Data/Code/Use Conversion Table. This is Minitab’s version of Excels vlookup function.

    Feel free to message me and I will walk you though it. It’s doable.

    0
    #191736

    You can remove the extra characters with a series of SUBSTITUE commands in Minitab using the calculator as:

    SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(C1,”+”,””),” “,””),”(“,””),”)”,””)

    This will remove all of the parentheses, spaces, and plus signs.

    0
Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.