place text in one cell

C

cmmssmith

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

cmmssmith

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 "x" in the cells directly below
series L1-Z1 (ie L2-Z2)

Cmmssmith
 
S

Sloth

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
=A1&" "&B1&" "&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.
 
Top