ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   place text in one cell (https://www.excelbanter.com/excel-worksheet-functions/80684-place-text-one-cell.html)

cmmssmith

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

Peo Sjoblom

place text 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

http://nwexcelsolutions.com




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




cmmssmith

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

Cmmssmith

"Peo Sjoblom" wrote:

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

http://nwexcelsolutions.com




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





Sloth

place text in one cell
 
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.

"cmmssmith" wrote:

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



All times are GMT +1. The time now is 12:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com