If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
numbering items in a cell
Hi,
Is it possible to number items in a cell? This number should automatically increment when I enter a new item at the end of the cell as in microsoft word. Thanks! |
#2
|
|||
|
|||
numbering items in a cell
Is it possible to number items in a cell?
If there's some kind of unique delimiter that separates the items then you can count the delimiters and add 1. For example: 1,2,3 You'd count the number of commas and add 1. So, that cells contains 3 items red yes no blue You'd count the number of space characters and add 1. So, that cell contains 4 items. You should post some examples. -- Biff Microsoft Excel MVP "Maanu" wrote in message ... Hi, Is it possible to number items in a cell? This number should automatically increment when I enter a new item at the end of the cell as in microsoft word. Thanks! |
#3
|
|||
|
|||
numbering items in a cell
One method:
In A1 enter a 1 In A2 enter: =IF(OR(B20,B2""),A1+1,"") and copy down (you could then hide column A) In C2 enter: =A2&" "&B2 and copy down Now in column B (starting in B2) enter your data. Column C should give you the desired result "Maanu" wrote: Hi, Is it possible to number items in a cell? This number should automatically increment when I enter a new item at the end of the cell as in microsoft word. Thanks! |
#4
|
|||
|
|||
numbering items in a cell
An example is given below. All the items given below is in the same cell
1. Manu 2. Mini 3. Saiju if I press alt+enter the next item should start with 4. "T. Valko" wrote: Is it possible to number items in a cell? If there's some kind of unique delimiter that separates the items then you can count the delimiters and add 1. For example: 1,2,3 You'd count the number of commas and add 1. So, that cells contains 3 items red yes no blue You'd count the number of space characters and add 1. So, that cell contains 4 items. You should post some examples. -- Biff Microsoft Excel MVP "Maanu" wrote in message ... Hi, Is it possible to number items in a cell? This number should automatically increment when I enter a new item at the end of the cell as in microsoft word. Thanks! . |
#5
|
|||
|
|||
numbering items in a cell
All the items given below is in the same cell
if I press alt+enter the next item should start with 4. Yikes! I don't know how you'd do that all in the same cell. In fact, I'd love to see someones solution. I don't think it can be done. While you're typing data into a cell Excel is in Edit mode. Nothing can happen in Excel while you're in Edit mode until you actually enter the data in the cell by either hitting the Enter key, the tab key, one of the directional arrow keys or clicking the "enter" icon. -- Biff Microsoft Excel MVP "Maanu" wrote in message ... An example is given below. All the items given below is in the same cell 1. Manu 2. Mini 3. Saiju if I press alt+enter the next item should start with 4. "T. Valko" wrote: Is it possible to number items in a cell? If there's some kind of unique delimiter that separates the items then you can count the delimiters and add 1. For example: 1,2,3 You'd count the number of commas and add 1. So, that cells contains 3 items red yes no blue You'd count the number of space characters and add 1. So, that cell contains 4 items. You should post some examples. -- Biff Microsoft Excel MVP "Maanu" wrote in message ... Hi, Is it possible to number items in a cell? This number should automatically increment when I enter a new item at the end of the cell as in microsoft word. Thanks! . |
#6
|
|||
|
|||
numbering items in a cell
Cannot be done.
Excel knows nothing about bulleted lists. You will have to enter the "4." manually after Alt + Enter on 3. Saiju Gord Dibben MS Excel MVP On Fri, 26 Mar 2010 21:30:01 -0700, Maanu wrote: An example is given below. All the items given below is in the same cell 1. Manu 2. Mini 3. Saiju if I press alt+enter the next item should start with 4. "T. Valko" wrote: Is it possible to number items in a cell? If there's some kind of unique delimiter that separates the items then you can count the delimiters and add 1. For example: 1,2,3 You'd count the number of commas and add 1. So, that cells contains 3 items red yes no blue You'd count the number of space characters and add 1. So, that cell contains 4 items. You should post some examples. -- Biff Microsoft Excel MVP "Maanu" wrote in message ... Hi, Is it possible to number items in a cell? This number should automatically increment when I enter a new item at the end of the cell as in microsoft word. Thanks! . |
Thread Tools | |
Display Modes | |
|
|