seperate numbers in a cell

  • Thread starter Thread starter rglasunow
  • Start date Start date
R

rglasunow

If I've got a cell with a 12 digit number it it (123456789123). Is i
possible to take that number and place each digit into its own cell?
1 goes to D6
2 goes to E6
etc...

Thank you
 
Use Data>Text ToColumns with a fixed width of 1 character.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top