auto add "1" to end of value

S

Stinky

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
 
J

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
 
D

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
 
D

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
Click to expand...

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