| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Removing characters
Hello,
I have needed advice from you or a formula for removing the some characters from the cell or columns, For example If I have column formatted like text or numbers, and I would like to remove first one or first two numbers (characters) on the beginning of the field if they are 0, Examle: Tel. number 03265598 0059842367 05478896 45623178956 00246645898 12355698 The results that I would like to have a Tel. number 3265598 59842367 5478896 45623178956 246645898 12355698 The same column, but only without 0 Β· The column is formatted like text. I hope that you are going to help me, giving me advice how can I do this or maybe the problem can be solved by formula. Thank you. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Removing characters from a cell (keeping only the numbers) | Excel Discussion (Misc queries) | |||
| Removing characters from a cell (keeping only numbers) 2 | Excel Discussion (Misc queries) | |||
| Removing unwanted characters | Excel Discussion (Misc queries) | |||
| removing pre-set characters from comments | Excel Worksheet Functions | |||
| Removing Non-Numeric Characters | Excel Discussion (Misc queries) | |||
Threaded Mode
