Hi all

is there a function i can use to append some character to a cell

Example:

cell contains ABC

i am looking for something the can add a Y harcter either at the
beginning or at the end of the content like in YABC or ABCY

thank u

If ABC is in A1,
=A1&"Y"
delivers ABCY

Steve


"glenn" <(E-Mail Removed)> wrote in message
news:fdh3qa$ser$(E-Mail Removed)...
> Hi all
>
> is there a function i can use to append some character to a cell
>
> Example:
>
> cell contains ABC
>
> i am looking for something the can add a Y harcter either at the beginning
> or at the end of the content like in YABC or ABCY
>
> thank u

A formula in Excel:

=a1&"Y"
or
="Y"&a1

In code:

with activesheet.range("a1")
.value = "Y" & .value
'or
.value = .value & "Y"
end with

glenn wrote:
>
> Hi all
>
> is there a function i can use to append some character to a cell
>
> Example:
>
> cell contains ABC
>
> i am looking for something the can add a Y harcter either at the
> beginning or at the end of the content like in YABC or ABCY
>
> thank u

--

Dave Peterson