Append character to cell
 

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

Append character to cell
 

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

Steve


"glenn" wrote in message
...
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

Append character to cell
 

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