Telefonnummern -- Verschiedene Formate einheitlich formatieren

%3CLINGO-SUB%20id%3D%22lingo-sub-3346536%22%20slang%3D%22de-DE%22%3EPhone%20Numbers%20--%20Format%20Different%20Formats%20Consistently%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3346536%22%20slang%3D%22de-DE%22%3E%3CP%3EHello%2C%20my%20table%20of%20phone%20numbers%20looks%20similar%20to%20the%20following%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%2B49%20(0)%20123%20456%20789%3C%2FP%3E%3CP%3E1805-171829%3C%2FP%3E%3CP%3E004921123456789%3C%2FP%3E%3CP%3E030%2F18%2017%2016%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EProblem%2C%20the%20PBX%20needs%20a%200%20in%20advance%20to%20call%20out.%20The%20phone%20book%20must%20therefore%20have%20either%200021123456789%20or%20%2B49%2021123456789.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20do%20I%20get%20a%20uniform%20format%20without%20deleting%20the%200%20when%20%22formatting%22%20and%20still%20following%20it%3F%20with%20formulas%20such%20as%20%22%3Dreplace(...)%20%22%20to%20be%20able%20to%20work%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3346536%22%20slang%3D%22de-DE%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hallo, meine Tabelle mit Telefonnummern sieht ähnlich wie folgt aus:

 

+49 (0) 123 456 789

1805-171829

004921123456789

030/18 17 16

 

Problem, die TK-Anlage braucht eine 0 vorweg um rauszutelefonieren. Das Telefonbuch muss also entweder 0021123456789 oder +49 21123456789 haben.

 

Wie kriege ich ein einheitliches Format hin, ohne beim "formatieren" die 0 zu löschen und aber trotzdem anschl. mit Formeln wie "=ersetzen(...)" arbeiten zu können? 

0 Replies