Formatting cell for phone numbers

Giganews Newsgroups
Subject: Formatting cell for phone numbers
Posted by:  Craig (cwsi…
Date: 8 Oct 2003

I am trying to format a cell with phone numbers so that it will look
like the following:

(937) 123-3456
(937) 129-9876 fax
(937) 123-3456

The word 'fax' is more specifically a label, not necessarily that
word. I would like to have carriage returns between the numbers with
the possibility of several numbers. This may be confusing and/or too
complicated, but I'd like to give it a try. If anyone as suggestions
or possible solutions, I would appreciate hearing them.