C D
2 422366
3 30000285
4 409997
5 431094
6 30000265
7 431167
8 30000326
9 465561
10 469002
431170
30000157

I need to move all codes that begin with the number 4 over one column in
place.
C D
1 422366
2 30000285
3 409997
4 431094
5 30000265
6 431167
7 30000326
8 465561
9 469002
10 431170
30000157



"Marcelo" wrote:

=IF(LEFT(C6;1)="4";C6;"")
hth
--
pleae click yes if it was helpfull
regards from Brazil
Marcelo



"Katerinia" escreveu:

Column C has multiple codes
I need to seperate the codes that start with the number 4
from the codes that start with the number 3
and past codes starting with number 4, into empty column D in the same
position they were in Column C

Thanks!