Text to Columns in Access

[jeffgeorge]

Trying to split a column in Access with all fields having the format:

COLUMN:[NUMBER(fixed length) NAME(varying length)]

I see in Excel they have a Text to Columns function which creates two
columns which seperate the NUMBER and NAME. Does Access have this
functionality. Can kick it out to Excel but I'm over the 65,000 rows
and would have to split, etc.

[Phil Stanton]

Try
Number: Left(Column,5) assuming this is a 5 digit ficed length
number with leading zeros
Name :Right(Column,Len(Column)-5)
Phil

"jeffgeorge" <ki*******@aol.com> wrote in message
news:4f**************************@posting.google.c om...

Trying to split a column in Access with all fields having the format:

COLUMN:[NUMBER(fixed length) NAME(varying length)]

I see in Excel they have a Text to Columns function which creates two
columns which seperate the NUMBER and NAME. Does Access have this
functionality. Can kick it out to Excel but I'm over the 65,000 rows
and would have to split, etc.

[jeffgeorge]

Thanks Phil. The column looks like this 1000258 SmithCorp. The
numbers are always the same length but the names vary in size and
sometimes have spaces. I think the format of how I posted made it
confusing and don't know if I can get to the solution from your post.
I will try to create two new columns using your post as a guide.

"Phil Stanton" <di********@stantonfamily.co.uk> wrote in message news:<3f***********************@mercury.nildram.ne t>...

Try
Number: Left(Column,5) assuming this is a 5 digit ficed length
number with leading zeros
Name :Right(Column,Len(Column)-5)
Phil

"jeffgeorge" <ki*******@aol.com> wrote in message
news:4f**************************@posting.google.c om...

Trying to split a column in Access with all fields having the format:

COLUMN:[NUMBER(fixed length) NAME(varying length)]

I see in Excel they have a Text to Columns function which creates two
columns which seperate the NUMBER and NAME. Does Access have this
functionality. Can kick it out to Excel but I'm over the 65,000 rows
and would have to split, etc.

[jeffgeorge]

Excellent Phil. Entered my expressions and columns are seperated. gracias.

"Phil Stanton" <di********@stantonfamily.co.uk> wrote in message news:<3f***********************@mercury.nildram.ne t>...

Try
Number: Left(Column,5) assuming this is a 5 digit ficed length
number with leading zeros
Name :Right(Column,Len(Column)-5)
Phil

"jeffgeorge" <ki*******@aol.com> wrote in message
news:4f**************************@posting.google.c om...

Trying to split a column in Access with all fields having the format:

COLUMN:[NUMBER(fixed length) NAME(varying length)]

I see in Excel they have a Text to Columns function which creates two
columns which seperate the NUMBER and NAME. Does Access have this
functionality. Can kick it out to Excel but I'm over the 65,000 rows
and would have to split, etc.