Excel Formula
 

I have a list of number all starting with the first three numbers 011, which
I need to remove completely from the rest of the numbers. Normally I would
remove them with =product(a1:a1,100), however it is not working. Do I have
something wrong with the formula? The list of numbers are located in row A1
to A13,000 in my excel 2007 file, I am placing the formula in cell B1. If
someone can help me out I would really appreciate it.

Excel Formula
 

The formula will give you the product of A1 and 100, and so is equivalent to
=100*A1.
I'm not convinced that you intended to do that.
--
David Biddulph

"Claude" wrote in message
...
I have a list of number all starting with the first three numbers 011,
which
I need to remove completely from the rest of the numbers. Normally I
would
remove them with =product(a1:a1,100), however it is not working. Do I
have
something wrong with the formula? The list of numbers are located in row
A1
to A13,000 in my excel 2007 file, I am placing the formula in cell B1. If
someone can help me out I would really appreciate it.

Excel Formula
 

If all the numbers start with 011, you could could either use text to columns
and force it to split on ","s

or

=MID(J12,4,255)

will remove the first three numbers - if comma's are not present


--
Wag more, bark less


"Claude" wrote:

I have a list of number all starting with the first three numbers 011, which
I need to remove completely from the rest of the numbers. Normally I would
remove them with =product(a1:a1,100), however it is not working. Do I have
something wrong with the formula? The list of numbers are located in row A1
to A13,000 in my excel 2007 file, I am placing the formula in cell B1. If
someone can help me out I would really appreciate it.