Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting Phone Numbers in a Merged Cells...
If I want to merge a "Company Name", "Phone Number" and a "Fax" 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: =A3&" Phone: "&B3&" Fax: "&C3 I am tired of trying to get it to work, and can't seem to find the answer here. Thank you in advance! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting Phone Numbers in a Merged Cells...
One way:
=A3 & TEXT(B3,""" Phone: ""000-000-0000") & TEXT(C3,""" Fax: ""000-000-0000") In article , "Steve" wrote: If I want to merge a "Company Name", "Phone Number" and a "Fax" 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: =A3&" Phone: "&B3&" Fax: "&C3 I am tired of trying to get it to work, and can't seem to find the answer here. Thank you in advance! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting Phone Numbers in a Merged Cells...
Thank you very much!
"JE McGimpsey" wrote: One way: =A3 & TEXT(B3,""" Phone: ""000-000-0000") & TEXT(C3,""" Fax: ""000-000-0000") In article , "Steve" wrote: If I want to merge a "Company Name", "Phone Number" and a "Fax" 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: =A3&" Phone: "&B3&" Fax: "&C3 I am tired of trying to get it to work, and can't seem to find the answer here. Thank you in advance! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selecting & Formatting Columns w/ Merged Cells | New Users to Excel | |||
Conditional formatting...cont. from 9/25 | Excel Discussion (Misc queries) | |||
I Need a Formula to Auto-fill Phone Numbers in a Range | Excel Worksheet Functions | |||
Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
Cells losing formatting | Excel Discussion (Misc queries) |