software

If I want to merge a quot;Company Namequot;, quot;Phone Numberquot; and a quot;Faxquot; number into
1 cell (for use in a drop down box), is there a way to maintain the 10 digit
format for the phone/fax numbers?

The phone/fax #'s appear as a string of 10 digits when they are merged, and
are hard to read.

Currently using a formula like this: =A3amp;quot; Phone: quot;amp;B3amp;quot; Fax: quot;amp;C3

I am tired of trying to get it to work, and can't seem to find the answer
here.

Thank you in advance!
One way:

=A3 amp; TEXT(B3,quot;quot;quot; Phone: quot;quot;000-000-0000quot;) amp; TEXT(C3,quot;quot;quot; Fax:
quot;quot;000-000-0000quot;)

In article gt;,
quot;Stevequot; gt; wrote:

gt; If I want to merge a quot;Company Namequot;, quot;Phone Numberquot; and a quot;Faxquot; number into
gt; 1 cell (for use in a drop down box), is there a way to maintain the 10 digit
gt; format for the phone/fax numbers?
gt;
gt; The phone/fax #'s appear as a string of 10 digits when they are merged, and
gt; are hard to read.
gt;
gt; Currently using a formula like this: =A3amp;quot; Phone: quot;amp;B3amp;quot; Fax: quot;amp;C3
gt;
gt; I am tired of trying to get it to work, and can't seem to find the answer
gt; here.
gt;
gt; Thank you in advance!

Thank you very much!

quot;JE McGimpseyquot; wrote:

gt; One way:
gt;
gt; =A3 amp; TEXT(B3,quot;quot;quot; Phone: quot;quot;000-000-0000quot;) amp; TEXT(C3,quot;quot;quot; Fax:
gt; quot;quot;000-000-0000quot;)
gt;
gt; In article gt;,
gt; quot;Stevequot; gt; wrote:
gt;
gt; gt; If I want to merge a quot;Company Namequot;, quot;Phone Numberquot; and a quot;Faxquot; number into
gt; gt; 1 cell (for use in a drop down box), is there a way to maintain the 10 digit
gt; gt; format for the phone/fax numbers?
gt; gt;
gt; gt; The phone/fax #'s appear as a string of 10 digits when they are merged, and
gt; gt; are hard to read.
gt; gt;
gt; gt; Currently using a formula like this: =A3amp;quot; Phone: quot;amp;B3amp;quot; Fax: quot;amp;C3
gt; gt;
gt; gt; I am tired of trying to get it to work, and can't seem to find the answer
gt; gt; here.
gt; gt;
gt; gt; Thank you in advance!
gt;