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