auto add "1" to end of value

[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

[James]

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
>.
>

[Stinky]

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
> >.
> >
>

[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


>-----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
>> >.
>> >
>>
>.
>

[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


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

[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
>
>
> 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