Need to split a 17 digit number into 17 cells by paste function.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

The desighn of this sheet requires a larger text that, just pasting, does not
accomplish. Is there a way without adding commas to paste a 17 digit number
across 17 differernt cells in succession? EG : 1FABP26852L576218.. I need to
paste this number as is above , but need it to split each character of the
number and drop it into a sequential cell in a row.. Eg: 1 in cell c24 F in
cell d24,, A in cell e24.. and so on. I can't for the life of me figure why
this would be usefull in excell but I am trying to make this sheet fit the
presentation of the print... any suggestios would be much appreciated...
thank you in advance.
 
Hi Jimbo,

Text to columns will do that.

Select your data,
Go to Data>Text to columns
Check Fixed width and next
Then add your column breaks by clicking on the scale
just above the data.
Click finish and you are done.

HTH
Martin
 
The desighn of this sheet requires a larger text that, just pasting, does not
accomplish. Is there a way without adding commas to paste a 17 digit number
across 17 differernt cells in succession? EG : 1FABP26852L576218.. I need to
paste this number as is above , but need it to split each character of the
number and drop it into a sequential cell in a row.. Eg: 1 in cell c24 F in
cell d24,, A in cell e24.. and so on. I can't for the life of me figure why
this would be usefull in excell but I am trying to make this sheet fit the
presentation of the print... any suggestios would be much appreciated...
thank you in advance.
Click to expand...

A formula solution could be, with your string in B24

C24: =MID($B$24,COLUMNS($A:A),1)

Fill right to S24


--ron
 
Back
Top