Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Number Bullets
I am trying to have number bullets in Excel. I am able to use the function
concatenate, but it does not increment the numbers, such as 1 1.1 1.1.1, 1.1.1, 1.1.1 (I need 1.1.1, then 1.1.2, and 1.1.3). This is an example of what I am using =CONCATENATE($B$4,".",$I$2). The $B$4 value is 1.1 and $I$2 value is 1 Is it possible to do in excel? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Number Bullets
Instead of CONCATENATE, you can just build the string:
=$B$4 & "." & $I$2 There is no way to increment automatically, but you can either refer to another part of the sheet in your formula that has incremental numbers ORyou can try using the ROW command which will increment as you copy down: = $B$4 & "." & ROW($A1) If you copy this formula down, the $A1 reference will increment along with the row value. Hope that helps... |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Number Bullets
Thanks for your help, it works.
I am also using the following code. Only difference is that my cell B2, B3, B4 & so on have the value 1,2,3 etc. =CONCATENATE($D$4,".",B2) =CONCATENATE($D$4,".",B3) " wrote: Instead of CONCATENATE, you can just build the string: =$B$4 & "." & $I$2 There is no way to increment automatically, but you can either refer to another part of the sheet in your formula that has incremental numbers ORyou can try using the ROW command which will increment as you copy down: = $B$4 & "." & ROW($A1) If you copy this formula down, the $A1 reference will increment along with the row value. Hope that helps... |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Number Bullets
=$B$4&"."&$I$4+ROW(A1)-1
-- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "Timmy" wrote in message ... Thanks for your help, it works. I am also using the following code. Only difference is that my cell B2, B3, B4 & so on have the value 1,2,3 etc. =CONCATENATE($D$4,".",B2) =CONCATENATE($D$4,".",B3) " wrote: Instead of CONCATENATE, you can just build the string: =$B$4 & "." & $I$2 There is no way to increment automatically, but you can either refer to another part of the sheet in your formula that has incremental numbers ORyou can try using the ROW command which will increment as you copy down: = $B$4 & "." & ROW($A1) If you copy this formula down, the $A1 reference will increment along with the row value. Hope that helps... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excell-How to add the number of cells containing text? = a sum | Excel Worksheet Functions | |||
Generating (in a random order)each number once from a given number | Excel Worksheet Functions | |||
Change number format from text to number? | New Users to Excel | |||
vlookup with more than number to be retrieved | Excel Worksheet Functions | |||
Count Number of Characters in a cell? | Excel Discussion (Misc queries) |