combine cells

  • Thread starter Thread starter Ray
  • Start date Start date
R

Ray

I have NPA (225) in a cell B3
I have NXX (442) in the next cell B4
I want to combine the two cells into one cell 225-442
Is there a function that will accomplish this? I have a
ton of numbers to do!

thanks
 
It's hard to tell from you post - is "NPA" part of the cell or is
225 an example of NPA data? Assuming the former, and assuming that
all your numbers are three digits long:



B3: NPA (225)
B4: NXX (442)
B5: =MID(B3,FIND("(",B3)+1,3) & "-" & MID(B4,FIND("(",B4)+1,3)
 
Back
Top