combine cells

[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

 

[Don Guillett]

will this work?
=b3&"-"&b4

 

[Ron de Bruin]

Hi Ray

In B5 for example place this formula
=B3 &"-" & B4

 

[J.E. McGimpsey]

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)

 

[Harald Staff]

=B3&"-"&B4

 

[Ray]

Thanks Gang!!!!

-----Original Message-----
Hi Ray

In B5 for example place this formula
=B3 &"-" & B4



--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)







.