Copy Cells Found

[S1L1Y1]

This post does not belong here but I tried the Office Group but got no
answer and here I always get a solution.
I would like to ask if there is a way that I can add the same text to
existing text in all cells in column. Each cell has deferent text. I have
office XP.
Sol

 

[Don Phillipson]

"S1L1Y1" <s1l1y1@yahoo.com> wrote in message
news:uckPX51tIHA.2292@TK2MSFTNGP03.phx.gbl...

> This post does not belong here but I tried the Office Group but got no
> answer and here I always get a solution.
> I would like to ask if there is a way that I can add the same text to
> existing text in all cells in column. Each cell has deferent text. I have
> office XP.

You seem to be asking about Excel, running under WinXP.
Your general answer is yes: it ought to be possible to write
a macro that appends a fixed text string to a different text
string in a cell, and can be applied to multiple cells.

--
Don Phillipson
Carlsbad Springs
(Ottawa, Canada)

 

[Franc Zabkar]

On Fri, 16 May 2008 10:08:28 -0400, "S1L1Y1" <s1l1y1@yahoo.com> put
finger to keyboard and composed:

>This post does not belong here but I tried the Office Group but got no
>answer and here I always get a solution.
>I would like to ask if there is a way that I can add the same text to
>existing text in all cells in column. Each cell has deferent text. I have
>office XP.
>Sol

Assuming the existing text is in column A, you could use the following
function to create a new column. Then just copy and paste the new cell
formula to all cells within the new column.

=CONCATENATE(A1,"your_added_text")

- Franc Zabkar
--
Please remove one 'i' from my address when replying by email.

 

[Gary S. Terhune]

Easier: Once you put the code into the top cell of the column, grab the
lower right corner of the cell with the mouse and drag down to fill the
column, or there's probably even an easier way, though for some reason Fill
>Down isn't available, only Fill>Right or Fill>Left.

--
Gary S. Terhune
MS-MVP Shell/User
www.grystmill.com

"Franc Zabkar" <fzabkar@iinternode.on.net> wrote in message
news:rt6t245d431de84b86skr017funh2jhsh7@4ax.com...
> On Fri, 16 May 2008 10:08:28 -0400, "S1L1Y1" <s1l1y1@yahoo.com> put
> finger to keyboard and composed:
>
>>This post does not belong here but I tried the Office Group but got no
>>answer and here I always get a solution.
>>I would like to ask if there is a way that I can add the same text to
>>existing text in all cells in column. Each cell has deferent text. I have
>>office XP.
>>Sol
>
> Assuming the existing text is in column A, you could use the following
> function to create a new column. Then just copy and paste the new cell
> formula to all cells within the new column.
>
> =CONCATENATE(A1,"your_added_text")
>
> - Franc Zabkar
> --
> Please remove one 'i' from my address when replying by email.

 

[Franc Zabkar]

On Sat, 17 May 2008 09:03:18 -0700, "Gary S. Terhune" <none> put
finger to keyboard and composed:

>Easier: Once you put the code into the top cell of the column, grab the
>lower right corner of the cell with the mouse and drag down to fill the
>column, or there's probably even an easier way, though for some reason Fill
> >Down isn't available, only Fill>Right or Fill>Left.

Select the new cell and copy it (Ctrl-C). Now click the top of the new
column to highlight the whole column and then paste (Ctrl-V).

The above works in Excel 5.0. I have no idea whether it works in
current versions of MS Office.

- Franc Zabkar
--
Please remove one 'i' from my address when replying by email.

 

[Gary S. Terhune]

Probably does. Too bad I'll never remember it, <sigh>.

--
Gary S. Terhune
MS-MVP Shell/User
www.grystmill.com

"Franc Zabkar" <fzabkar@iinternode.on.net> wrote in message
news:ffgu24tol2eqnd1pjpllvkf3hhsbbolequ@4ax.com...
> On Sat, 17 May 2008 09:03:18 -0700, "Gary S. Terhune" <none> put
> finger to keyboard and composed:
>
>>Easier: Once you put the code into the top cell of the column, grab the
>>lower right corner of the cell with the mouse and drag down to fill the
>>column, or there's probably even an easier way, though for some reason
>>Fill
>> >Down isn't available, only Fill>Right or Fill>Left.
>
> Select the new cell and copy it (Ctrl-C). Now click the top of the new
> column to highlight the whole column and then paste (Ctrl-V).
>
> The above works in Excel 5.0. I have no idea whether it works in
> current versions of MS Office.
>
> - Franc Zabkar
> --
> Please remove one 'i' from my address when replying by email.