LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Removing characters Maksko Excel Discussion (Misc queries) 7 October 19th 06 02:26 PM
Removing characters from a cell (keeping only the numbers) Monk Excel Discussion (Misc queries) 9 January 24th 06 03:32 PM
Removing characters from a cell (keeping only numbers) 2 Monk Excel Discussion (Misc queries) 6 January 24th 06 02:45 PM
Removing unwanted characters Scorpvin Excel Discussion (Misc queries) 8 December 5th 05 09:07 PM
removing pre-set characters from comments Matt G. Excel Worksheet Functions 3 November 15th 05 11:12 PM


All times are GMT +1. The time now is 07:43 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"