A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

numbering items in a cell



 
 
Thread Tools Display Modes
  #1  
Old March 26th, 2010, 06:46 PM posted to microsoft.public.excel.misc
Maanu
external usenet poster
 
Posts: 27
Default 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  
Old March 26th, 2010, 06:59 PM posted to microsoft.public.excel.misc
T. Valko
external usenet poster
 
Posts: 15,759
Default 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  
Old March 26th, 2010, 07:16 PM posted to microsoft.public.excel.misc
Ron@Buy
external usenet poster
 
Posts: 348
Default 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  
Old March 27th, 2010, 05:30 AM posted to microsoft.public.excel.misc
Maanu
external usenet poster
 
Posts: 27
Default 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  
Old March 27th, 2010, 06:34 AM posted to microsoft.public.excel.misc
T. Valko
external usenet poster
 
Posts: 15,759
Default 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  
Old March 27th, 2010, 04:01 PM posted to microsoft.public.excel.misc
Gord Dibben
external usenet poster
 
Posts: 20,252
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:03 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.