Hi JGlen,

if will always the first 3 numbers on the b column and the rest on the C

use:

B column
=left(a2,3)

C Colum
=right(a2,(len(a2)-len(b2))

hth
regards from Brazil
Marcelo

"jglen" escreveu:

I would like to know how to split ie 123456789 in cell A1 to 123 in B1, and
456789 in C1. Is there a formula that can do this for me?