View Single Post
  #2   Report Post  
ScottO
 
Posts: n/a
Default

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, )?