append a string of text to all cells in a column?

's Computer Specifications

Excel 2003
Is there a way to do this?
The cells that I want to append to all contaio plain text.

Thanks!

....Lisa

's Computer Specifications

Lisa

Assuming column of text is A

In B1 enter =A1 & "textstring"

Double-click on the fill handle of B1 to copy down.

Gord Dibben MS Excel MVP

On Wed, 14 Feb 2007 17:37:14 -0500, "Lisa Hetherington"
<(E-Mail Removed)> wrote:

>Excel 2003
>Is there a way to do this?
>The cells that I want to append to all contaio plain text.
>
>Thanks!
>
>...Lisa
>

's Computer Specifications

Thank you!!

....Lisa
"Gord Dibben" <gorddibbATshawDOTca> wrote in message
news:(E-Mail Removed)...
> Lisa
>
> Assuming column of text is A
>
> In B1 enter =A1 & "textstring"
>
> Double-click on the fill handle of B1 to copy down.
>
>
> Gord Dibben MS Excel MVP
>
> On Wed, 14 Feb 2007 17:37:14 -0500, "Lisa Hetherington"
> <(E-Mail Removed)> wrote:
>
>>Excel 2003
>>Is there a way to do this?
>>The cells that I want to append to all contaio plain text.
>>
>>Thanks!
>>
>>...Lisa
>>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Append a wildcard to a text search string	tstew	Microsoft Access Forms	3	13th Oct 2009 04:16 AM
Formula to count text string in column cells of filtered rows	JSS	Microsoft Excel Worksheet Functions	3	2nd Oct 2009 05:18 PM
Display cells(text) in one column based on cells which are present inother column	sunnykumar948@gmail.com	Microsoft Excel Misc	1	12th May 2008 01:40 PM
How do I append same text to all the cells in a column at once?	=?Utf-8?B?QWJoaWppdCBCYW1pc2h0ZQ==?=	Microsoft Excel Worksheet Functions	4	15th Dec 2006 07:26 PM
How do I append data in several cells in one column	=?Utf-8?B?VGlt?=	Microsoft Excel Misc	4	16th Nov 2005 10:04 PM