Extract characters

  • Thread starter Thread starter Ivor Williams
  • Start date Start date
I

Ivor Williams

I have a string of numbers 28347465 in column A. I want to extract the
first, third, fifth and seventh numbers and put them into their own columns.
So 2 would be in column B, 3 would be in column C, 7 would be in column D,
and 6 would be in column E. How can I do this?

Ivor
 
Hi Ivor,

Try:

B1 =MID(A1,1,1)
C1 =MID(A1,3,1)
D1 =MID(A1,5,1)
E1 =MID(A1,7,1)
 
Hi
in B1 enter
=MID($A$1,(COLUMN()-2)*2+1,1)
and copy to the right
 
You must log in or register to reply here.

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

Speek cells, barcode scanner 3
Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3
list items from one table in another table based on value in first table 2
Figuring out a lengthy formula. Probably quite simple... 3
Extracting data from range and placing in one cell with comma'sbetween while ignoring blanks 5
Formatting and modelling 2
Show other cell if blank 5
Extract text 5

Back
Top