Hello, I have searched for a few hours and decided to finally ask for
help.

I have a column filled with part numbers they are made by having a
drawing #, material code, and finish code all seperated by a "." I
need to seperate the codes out into 3 seperate columns... here are some
row examples:

1025.925
1025.93
1027.868
1027.895
1044.157
1058.159
1058.159
1082.028
27809.619
27809.619
27809.708
27811.001
001138.825.000
001138.825.000
001138.825.000

they vary in length so it makes it difficult. I was trying to use some
infromation from other posts with the SEARCH( function or FIND(function
but those dont seem to work in VBA. Please help. Thanks

Colin

Wow, I knew there was something easy I was missing. Thanks :-)

/me feels stupid

On Jan 24, 11:18 am, Jim Thomlinson
wrote:
Have you tried doing Data - Text to Column - Specify Delimited and then
specify the delimiter as "."
--
HTH...

Jim Thomlinson

" wrote:
Hello, I have searched for a few hours and decided to finally ask for
help.

I have a column filled with part numbers they are made by having a
drawing #, material code, and finish code all seperated by a "." I
need to seperate the codes out into 3 seperate columns... here are some
row examples:

1025.925
1025.93
1027.868
1027.895
1044.157
1058.159
1058.159
1082.028
27809.619
27809.619
27809.708
27811.001
001138.825.000
001138.825.000
001138.825.000

they vary in length so it makes it difficult. I was trying to use some
infromation from other posts with the SEARCH( function or FIND(function
but those dont seem to work in VBA. Please help. Thanks

Colin