Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 - Formatting text in cell (character by character) | Excel Discussion (Misc queries) | |||
Append value to cell or cells | Excel Discussion (Misc queries) | |||
Append value to cell or cells | Excel Discussion (Misc queries) | |||
File Append Row by Cell value | Excel Programming | |||
macro to append one cell to another | Excel Programming |