software

Any suggestions on how I could extract text from multiple cells (in a row) to
be included in one cell.

One way, copy and paste the text into notepad first, then copy from notepad
, click in the formula bar of the selected cell and paste it--

Regards,

Peo Sjoblom

nwexcelsolutions.com

quot;cmmssmithquot; gt; wrote in message
...
gt; Any suggestions on how I could extract text from multiple cells (in a row)
gt; to
gt; be included in one cell.
Thanks Peo..

However I'm trying to do it all automaticly within excel. My specific task
is to place multiple names in on cell say h2, names that I'm looking to
include are in say L1 thru to Z1, based on a quot;xquot; in the cells directly below
series L1-Z1 (ie L2-Z2)

Cmmssmith

quot;Peo Sjoblomquot; wrote:

gt; One way, copy and paste the text into notepad first, then copy from notepad
gt; , click in the formula bar of the selected cell and paste it
gt;
gt;
gt; --
gt;
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; nwexcelsolutions.com
gt;
gt;
gt;
gt;
gt; quot;cmmssmithquot; gt; wrote in message
gt; ...
gt; gt; Any suggestions on how I could extract text from multiple cells (in a row)
gt; gt; to
gt; gt; be included in one cell.
gt;
gt;
gt;

you need VBA to do it automatically, but if you many, many rows, then you can
use the following procedure to speed it up a little.

Say the first three columns are the first, middle, and last names, and you
want to join them with spaces inbetween. In D1 enter the following formula
=A1amp;quot; quot;amp;B1amp;quot; quot;amp;C1
the copy the formula down to the bottom of your data. You can then copy
column D and paste special (selecting values) to remove the formula and have
just data. You can then delete any original columns that you don't need
anymore.

quot;cmmssmithquot; wrote:

gt; Any suggestions on how I could extract text from multiple cells (in a row) to
gt; be included in one cell.