Roger's formula works for me using the data you supplied and his instructions
about placement in C1 and copying down.


Gord Dibben MS Excel MVP


On Wed, 23 Jan 2008 11:28:09 -0800, Finding_Facts_NC
wrote:

I've tried both formulas and they are not returning the value I need. I need
to replace the three digit number with the first four digit number listed
below the three digit number(s).

"Roger Govier" wrote:

Hi

Assuming column C is empty at present, enter in C1
=IF(LEN(B1)=3,C2,B1)
and copy down to C6000

To fix the values, copy column CPaste Special Values
--

Regards
Roger Govier

"Finding_Facts_NC" wrote in
message ...
I have a column containing three digit numbers and four digit numbers. I
need to replace the three digit numbers with the first four digit number
listed below them.
Here's an example of the numbers listed in column "B" and what the result
should look like in column "C"

A B C
Co Name 1 119 5530
Co Name 1 449 5530
Co Name 1 5530 5530
Co Name 2 119 5513
Co Name 2 5513 5513
Co Name 3 119 5540
Co Name 3 449 5540
Co Name 3 559 5540
Co Name 3 5540 5540

There are over 6,000 rows. Is there a formula that will help me do this?