Copy Cells Found

[Guest 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

[Guest Don Phillipson]

Re: Copy Cells Found

 

"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)

[Guest Franc Zabkar]

Re: Copy Cells Found

 

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.

[Guest Gary S. Terhune]

Re: Copy Cells Found

 

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

http://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.

[Guest Franc Zabkar]

Re: Copy Cells Found

 

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.

[Guest Gary S. Terhune]

Re: Copy Cells Found

 

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

 

--

Gary S. Terhune

MS-MVP Shell/User

http://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.