Breaking up part numbers

C

colin.marker

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple Worksheets, Date 3
How to check a list for single letters between text 4
Trying to create a list of prices from a web page 2
Excel Concatenate with line breaks but ignore blank cells 3
Formatting help 4
sorting part numbers 2
DLOOKUP AND VLOOKUP IN VBA 2
Using SumProduct function in VBA 1

Top