ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I merge individual data now in multiple cells, in to one b. (https://www.excelbanter.com/excel-worksheet-functions/8067-how-do-i-merge-individual-data-now-multiple-cells-one-b.html)

Cris

How do I merge individual data now in multiple cells, in to one b.
 
I have numbers for example 1,2,7 in cell A1. In cell B1 I have 17,20,33,45

I need to have 1,2,7,17,20,33,45 all in one cell. My data is so large typing
it in really is a last resort.

HELP!!!!!!



Frank Kabel

Hi
=A1 & "," & B1

--
Regards
Frank Kabel
Frankfurt, Germany
"Cris" schrieb im Newsbeitrag
...
I have numbers for example 1,2,7 in cell A1. In cell B1 I have 17,20,33,45

I need to have 1,2,7,17,20,33,45 all in one cell. My data is so large
typing
it in really is a last resort.

HELP!!!!!!






All times are GMT +1. The time now is 03:16 AM.

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