![]() |
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. |
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. |
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. |
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 10:50 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com