Appending text in Excel

February 3, 2011 at 09:53:43
Specs: Windows Vista
How do I append text to all cells in the very beginning of the text. This current formula will append text to the end but need to have it added at the beginning. =G9&"new"

I appreciate your time and assistance


See More: Appending text in Excel

Report •

#1
February 3, 2011 at 10:54:48
Are you ready to be amazed?

="new"&G9

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
February 3, 2011 at 13:33:05
What a shocker! Is there a way to add the new without having to copy it to a new cell. For example, adding new to the column/cell G9 without putting it into a different cell?

Thanks


Report •

#3
February 3, 2011 at 13:39:43
Not without VBA.

Within Excel, you could use the formula in a different column and then use Copy...PasteSpecial...Values to replace the original column with the string created by the formula. After that just delete the extra column.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question