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:
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?


See More: find and replace

Report •

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

Find 711
Replace with blank

Worked for me.


Report •
Related Solutions

Ask Question