| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is there such thing as deoncantenate in excel?
I am trying to seperate out the characters within one cell into individual
cells, is there a way of doing this? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Is there such thing as deoncantenate in excel?
On Fri, 27 Nov 2009 14:48:01 -0800, Jonny 9 <Jonny
wrote: I am trying to seperate out the characters within one cell into individual cells, is there a way of doing this? With your string of characters in A1, B1: =MID($A1,COLUMNS($A:A),1) and fill right as far as required. Or: A2: =MID(A$1,ROWS($1:1),1) and fill down as far as required. --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel 2007 how to turn off the fixed decimal thing | Excel Discussion (Misc queries) | |||
| How do I get rid of that large "PAGE 1" thing in Excel? | New Users to Excel | |||
| add ins - i've managed to uninstall from excel but the thing still shows up when excel opens in msie 6?? | Setting up and Configuration of Excel | |||
| How to calculate in Excel sheet eg. add or divide any thing and i. | New Users to Excel | |||
| What is the main thing to remember to get started in EXCEL? | New Users to Excel | |||
Linear Mode
