Excel Formula

C

Claude

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.
 
D

David Biddulph

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.
 
B

Brad

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
 
Top