Insert a number a number in column
 

Hi,

I was wondering if any one could help me, I have some data which was
inputted incorrectly and I need to amend it, there seems to be a
pattern, its missing the number 1 before the number eg 31456 should be
131456. There are over 1000 records and would take a long time to do
manually, could anyone help me?

Thanks

Ashley


--
webfort
------------------------------------------------------------------------
webfort's Profile: http://www.excelforum.com/member.php...fo&userid=7964
View this thread: http://www.excelforum.com/showthread...hreadid=543233

Insert a number a number in column
 

Hi

If you put this formula in a cell beside the incorrect column and copy it
down through the column it should be OK

=VALUE(1&E4) where E4 is the cell containing the wrong data.


--
Sharon


"webfort" wrote:


Hi,

I was wondering if any one could help me, I have some data which was
inputted incorrectly and I need to amend it, there seems to be a
pattern, its missing the number 1 before the number eg 31456 should be
131456. There are over 1000 records and would take a long time to do
manually, could anyone help me?

Thanks

Ashley


--
webfort
------------------------------------------------------------------------
webfort's Profile: http://www.excelforum.com/member.php...fo&userid=7964
View this thread: http://www.excelforum.com/showthread...hreadid=543233