View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Steve Yandl Steve Yandl is offline
external usenet poster
 
Posts: 284
Default 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