Thank you ScottO, but My text entries are in the same cell as the numerical
bullets and the entries with the bullets have to be vertical.
I need to add 1a) before the text on one line in the same cell.
I need to add 1b) before the text on another line in the same cell
I need to add 1c) before the text to still another line in the same cell.

Before I was required to add the bullets I entered the information in one
cell as follows:
'- text entry then alt enter to go to next line
-text entry, alt enter
-text entry, alt enter and so on and so forth.

I now need to change the - to be a numberical bullet with a sub bullet for
lack of a better label of a, b, & c etc.


"ScottO" wrote:

You could use a "helper" column with a formula in it.
Assuming that your text entries are currently in ColA starting at Row2, try
....

=1&Char(Row(A2)+95)&") "&A2

Char(97) = "a", so this will only work for 26 items in your list - it'll go
feral after that.
The formula could be modified for leading 2,3,4, etc. if you need as well.

Rgds,
ScottO


"Daisy" wrote in message
...
| I am trying to insert several numerical bullets into a cell that contains
| text. For example,
| 1a) example 1
| 1b) example 2
| 1c) example 3
|
| How can I do this more easily than inserting 3 symbols 1, a, )?