auto add "1" to end of value

[Guest]

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

 

[James]

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

That should work.

 

[Guest]

thank you

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

That should work.

 

[James]

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

 

[Debra Dalgleish]

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

 

[David]

Debra Dalgleish wrote

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

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