i have 2 cells in my worksheet that i want a "1" to be added at the end of
whatever i type in the cell.

for example,

i type a value of "los angeles" in a1. i want to see "los angeles1" in the
cell a1


any help would be appreciated

In cell A2 type "1".
In cell A3 type "=A1&A2"

That should work.


-----Original Message-----
i have 2 cells in my worksheet that i want a "1" to be
added at the end of
whatever i type in the cell.

for example,

i type a value of "los angeles" in a1. i want to
see "los angeles1" in the
cell a1


any help would be appreciated
.

thank you

"James" wrote:

In cell A2 type "1".
In cell A3 type "=A1&A2"

That should work.


-----Original Message-----
i have 2 cells in my worksheet that i want a "1" to be
added at the end of
whatever i type in the cell.

for example,

i type a value of "los angeles" in a1. i want to
see "los angeles1" in the
cell a1


any help would be appreciated
.

Glad to help.

If you want a space between the end of "Los Angeles" and
the "1", as in "Los Angeles 1" rather than "Las Angeles1"
then in A3 type:

=A1&" "&A2


-----Original Message-----
thank you

"James" wrote:

In cell A2 type "1".
In cell A3 type "=A1&A2"

That should work.


-----Original Message-----
i have 2 cells in my worksheet that i want a "1" to
be
added at the end of
whatever i type in the cell.

for example,

i type a value of "los angeles" in a1. i want to
see "los angeles1" in the
cell a1


any help would be appreciated
.


.

Select the cells in which you want the 1
Choose FormatCells
On the Number tab, choose Custom
In the text box, type: @" 1"
Click OK


Stinky wrote:
i have 2 cells in my worksheet that i want a "1" to be added at the end of
whatever i type in the cell.

for example,

i type a value of "los angeles" in a1. i want to see "los angeles1" in the
cell a1


any help would be appreciated


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Debra Dalgleish wrote

Select the cells in which you want the 1
Choose FormatCells
On the Number tab, choose Custom
In the text box, type: @" 1"
Click OK


Stinky wrote:
i have 2 cells in my worksheet that i want a "1" to be added at the
end of whatever i type in the cell.

for example,

i type a value of "los angeles" in a1. i want to see "los angeles1"
in the cell a1


any help would be appreciated



Cool! And precisely what the OP asked for rather than results in another
cell.

--
David