View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Maksko Maksko is offline
external usenet poster
 
Posts: 6
Default Removing characters

Hi to all,

Of the beginning I would like to thank you for the advice about my previous
question, it was useful.

I have needed advice for a second time or maybe a formula for removing some
characters from the cell or columns,

For example
If I have column with a tel. numbers and I would like to remove first three
numbers (characters) if they are ``555`` on the beginning of the field.

Example:
Tel. number
5553265598
555984236
5478896
45623178956
78246645
555123556

The results that I would like to have a
Tel. number
3265598
984236
5478896
45623178956
78246645
123556
The same column, but only without €œ555€

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.