find and replace

showan January 29, 2009 at 03:40:21
Specs: Windows xp
Hello, I have column of numbers.
I would like to replace each number according to its value.
So for example my column of numbers is:
7118252805,7118258766,8252805,8262809,more...
I want to replace according to those rules:
If number begin 711??????? rewith a ???????(delet 711 and keep number)

How can I do this in Excel?

Thanks


See More: find and replace

Report •


#1
January 29, 2009 at 08:39:00
Have you tried
Edit > Replace

Find 711
Replace with blank

Worked for me.

MIKE


Report •
Related Solutions


Ask Question