| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need to split a 17 digit number into 17 cells by paste function.
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need to split a 17 digit number into 17 cells by paste function.
Hi Jimbo,
Text to columns will do that. Select your data, Go to DataText 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 "JIMBO" wrote: 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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need to split a 17 digit number into 17 cells by paste function.
On Wed, 10 Oct 2007 19:55:02 -0700, JIMBO
wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to validate a cell to insert from 9 digit number to 13 digit number. | Excel Worksheet Functions | |||
| How to validate a cell to insert from 9 digit number to 13 digit number. | Excel Worksheet Functions | |||
| How can i paste a 16 digit number in a excel worksheet? | Excel Discussion (Misc queries) | |||
| Color a single digit in a mult-digit number cell | Excel Discussion (Misc queries) | |||
| When we enter a 16 digit number (credit card) the last digit chan. | Excel Discussion (Misc queries) | |||
Linear Mode
