<Solved:>Display entire column in one cell

**portokie** · 12-17-2012, 05:30 PM

I want A1:A400 to display in B1. Thanks.

**oeldere** · 12-17-2012, 05:34 PM

b1

Please Login or Register  to view this content.

**portokie** · 12-17-2012, 05:44 PM

Not sum, columnA contains text strings only. I need something similar to A1&A2&A3, etc... but without so many characters. Thanks.

**portokie** · 12-17-2012, 06:39 PM

??????????

**Andrew-R** · 12-17-2012, 06:43 PM

A bit of VBA, perhaps?

Please Login or Register  to view this content.

Then:

=ConcatRange(A1:A400)

**portokie** · 12-17-2012, 07:30 PM

I've never used VBA before. What are the steps to input this code please? Thank you very much!

**Andrew-R** · 12-18-2012, 03:01 AM

With your workbook open (and it will be easiest if you only have this workbook open at the time):

Press Alt-F11, this will open the VBA editor
From the 'Insert' menu select 'Module' - this will open a blank text window
Paste my code into this text window
Close the VBA editor with the red cross at the top right of the screen
You can then use the formula in my post in that workbook.

Edited to add: If you're using Excel 2010 you'll no longer be able to save your workbook as a *.xlsx file, you'll have to save it as a .xlsm (macro-enabled workbook) instead.