excel math and text formulas

[ashliiii]

Hi,

When I write the following in cell A1, =1&")", I get

1)

in cell A1.

What formula should I write in cell A2 so that I can get,

2)

in cell A2.

I tried the following in cell A2, =a1 + 1, but I get an error.

Can anyone help me find the correct formula.

 

[rudfaden]

Try

=CELL("row";A1)&")"

 

[pgc01]

Hi

In A1:

=Row()&")"

Copy down

 

[Ron Coderre]

Here are a couple options:

A1: =ROWS($1:1)&")"
Copy that formula down as far as you need

or...
• Create a number series any way you want
• Select the series....e.g. A1:A200
• CTRL+1...(to open the formating dialog)
...Number_tab
...Category: Custom
...Type: 0)
...Click: OK

Does that help?

 

[ashliiii]

Ok, thank you all for your suggestions, all work well. But, what if I write on cell A1

1&")"

and I want a formula not in cell A2 but in cell A3 (or any cell I choose) so that I can get

2)

What formula should I type in cell A3 (or which ever cell I choose)

 

[pgc01]

Try:

=(LEFT(A1,LEN(A1)-1)+1)&")"

 

[T. Valko]

Ok, thank you all for your suggestions, all work well. But, what if I write on cell A1

1&")"

and I want a formula not in cell A2 but in cell A3 (or any cell I choose) so that I can get

2)

What formula should I type in cell A3 (or which ever cell I choose)

Here's another one...

=SUBSTITUTE(A1,")","")+1&")"