View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Marcelo Marcelo is offline
external usenet poster
 
Posts: 1,047
Default split column data

=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!