format cell with multiple formats for telephone numbers

  • Thread starter Thread starter Noe
  • Start date Start date
N

Noe

I have axla that I want to format telephone numbers in different formats.
#1 - 5 digit local PBX extension
#2 - normal 10 digit telephone with area code (123) 456-7890
#3 - 12 digit out-dialed number in our PBX; e.g. - 81 (123) 456-7890

I tried using multiple "conditions" but I am stuck on how to formal all of
the above combinations...

Currently I have this as a "condition" :

[<99999]#####;[>9999999999]##(###) ###-####


but I can't quite multiple conditions to work.
I tried this, but it threw an ERROR -

[<99999]#####;[>9999999999]##(###) ###-####;<9999999999>99999](###) ###-####

Help...
 
Back
Top