Excel question

[tcofran]

Good day guys / girls on MyBB

I have a large spreadsheet that needs to have "bullets" to be used as reference in another document

The first one will be "#1.1a)".....

How do i make excel increase the "a" when i drag the cells down ??? only the a, as the 1.1 must not change....

so it must be
#1.1a)
#1.1b)
#1.1c) etc etc etc

thanks in advance

 

[Drake2007]

Start a new worksheet, in column A put 97 then 98 below and drag that to fill
in column B put =char(A1), that will get your alphabet, drag to fill also.
from there you can build your string with e.g. =Concatenate( "1.1", B1, ")" )

or if you like
=CONCATENATE("1.1", CHAR(A1), ")" )

edit: you need to select the 97 and 98 together and then drag. btw it's only a to z, which like.. just type it out

 

[tcofran]

not having much luck, but thanks anyway......... Problem is it needs to go to #1.1nnnnnn) :wtf:

 

[hilton]

Easy, just do one column with static numbers/text and then another with the linear numbers and then a third with a formula to combine the first two. Once you are happy, hide the first two columns.

Make sense?

Sent from my GT-I9000 using MyBroadband Android App