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

[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.

 

[Guest]

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

 

[Ron Rosenfeld]

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.

A formula solution could be, with your string in B24

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

Fill right to S24


--ron