Split Numbers in a single cell

  • Thread starter Thread starter Tim
  • Start date Start date
T

Tim

I have a string of numbers in a cell and I want to split them into seperate
cells based on position. For example I need 080417007401181080 to be split
into 3 cells as follows, 080417/00740/1181080. Is there a macro I can run
that will automate this?

Thank you
Tim
 
Just make sure you designate the columns as text or you will lose the leading
zeros.


Gord Dibben MS Excel MVP
 
Hmm, kind of a toss up for me. If the numbers are required to be numbers
(depending on massaging the data) I would just reformat the columns
afterwards with a 000000/00000/0000000 format. Of course, if the OP wants
their numbers as text.. :)

Take care Gord.
 

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

splitting a single individual cell 7
VBA Multiple Line handling with Split() 1
splitting a single cell 1
Excel Count number of instances in a column 1
splitting contents of a cell by case? 1
Formula to split text and numbers 4
Splitting one cell into three. 2
TRIM IF CELL CONTAINS ONE WORD, ABBREVIATE IF IT CONTAINS MULTIPLE WORDS 1

Back
Top