Re: Copy multiple cells to one cell

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Herbert Seidenberg <herbds7-msxls@xxxxxxxxx>
Date: Wed, 26 Dec 2007 16:27:40 -0800 (PST)

Or if you don't want to do all that typing:
Copy A1:Z1
MS Word > Edit > Paste Special > Unformatted Text
MS Word > Edit > Find > Find what > ^t
Replace with > , > Replace All
Edit > Copy
MS Excel > Paste

Or if you want to stay in Excel
and dare to use iterate:
Tools > Options > Calculations > Manual
check iteration, set maximum to 26
C2 =0
B2 =IF(C2=0,1,B2+1)
A2 =IF(C2=0,"",A2&INDEX(1:1,B2)&",")
Change C2 to 1 and hit F9
The concatenated string will appear at A2
Select A2:B2 > Copy > Paste Special > Value
Uncheck iterate and set calculations to automatic
.

References:
- Re: Copy multiple cells to one cell
  - From: David Biddulph

Prev by Date: Re: Date format from yyyy-mm-dd-hh
Next by Date: Re: credit card spreadsheet
Previous by thread: Re: Copy multiple cells to one cell
Next by thread: Re: Copy multiple cells to one cell
Index(es):
- Date
- Thread

Relevant Pages

Re: Browse through components
... J French wrote: ... >> I have 10 TEditBox components I want to edit in one statement. ... >> Is there any way to iterate using their TabOrder property? ...
(alt.comp.lang.borland-delphi)
Brozse through components
... I have 10 TEditBox components I want to edit in one statement. ... Is there any way to iterate using their TabOrder property? ... Or any way to access the box whose name is 'Edit' + IntToStr? ... Eric Lafontaine ...
(alt.comp.lang.borland-delphi)