Append character to cell

G

glenn

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
 
D

Dave Peterson

A formula in Excel:

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

In code:

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Code character limit with Resize or Transpose or cell? 8
Column Cell character number checking 4
mix font attributes of text returned from cell formula 2
cell-based conditional formatting on the whole row (Excel 2007) 1
Manipulating Strings in a Macro 2
Need to append a character to cell data 1
move and modify exiting character in cell 5
Test if Last Character in Column of Cells is Alpha Character 6

Top