Insert text from column A into column B, before text in column B

Hi,

I am working with a very large database and I need to find a simple way
of inserting the text from 1 column and pasting it into another column,
which already has text in it. I want to paste this text to show up
before the text in the 2nd column. Here is an example:

COLUMN A
/images/products/

COLUMN B
AA-067.jpg

WHAT I WANT TO HAPPEN:
COLUMN B
/images/products/AA-067.jpg

Anyone have any ideas? Please let me know. I've been struggling with
what seems to be easy. Thanks


--
dbsupplements
------------------------------------------------------------------------
dbsupplements's Profile: http://www.excelforum.com/member.php...o&userid=25981
View this thread: http://www.excelforum.com/showthread...hreadid=393489

In Column C, temporarily, enter =A1&B1 and fill down as far as necessary.
Then, copy column C, select Column B and use Edit/Paste Special, click
Values. Then Clear column C. Column B now contains what was in A AND B.
Bob Umlas
Excel MVP

"dbsupplements" <dbsupplements.1tbfya_1123286701.0499@excelforum-nospam.com>
wrote in message
news:dbsupplements.1tbfya_1123286701.0499@excelfor um-nospam.com...
>
> Hi,
>
> I am working with a very large database and I need to find a simple way
> of inserting the text from 1 column and pasting it into another column,
> which already has text in it. I want to paste this text to show up
> before the text in the 2nd column. Here is an example:
>
> COLUMN A
> /images/products/
>
> COLUMN B
> AA-067.jpg
>
> WHAT I WANT TO HAPPEN:
> COLUMN B
> /images/products/AA-067.jpg
>
> Anyone have any ideas? Please let me know. I've been struggling with
> what seems to be easy. Thanks
>
>
> --
> dbsupplements
> ------------------------------------------------------------------------
> dbsupplements's Profile:
> http://www.excelforum.com/member.php...o&userid=25981
> View this thread: http://www.excelforum.com/showthread...hreadid=393489
>

Thanks a lot Bob, that worked perfectly. It sounds pathetic, but yo
helped A LOT

--
dbsupplement
-----------------------------------------------------------------------
dbsupplements's Profile: http://www.excelforum.com/member.php...fo&userid=2598
View this thread: http://www.excelforum.com/showthread.php?threadid=39348