LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
sierra
 
Posts: n/a
Default How to combine text from multiple cells?


How to combine text from many cells without writing each cell adress,
just the scope of cells?
Can I combine tex from cells A1 to A3 in a faster way than writing a
formula: '=A1&" "&A2&" "&A3' ? I need to find a way to combine text
from a really huge number of cells, like from B1 to B3489, and I want
to do it without writing every cell adress.


--
sierra
------------------------------------------------------------------------
sierra's Profile: http://www.excelforum.com/member.php...o&userid=25099
View this thread: http://www.excelforum.com/showthread...hreadid=386088

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding separate accumulators for multiple cells jrambo63 New Users to Excel 1 May 26th 05 06:56 PM
Format text across cells peterlsutton New Users to Excel 3 February 21st 05 07:54 PM
counting text cells Debbie Excel Worksheet Functions 4 February 8th 05 09:00 PM
Searching for text in cells Matt Excel Discussion (Misc queries) 1 January 31st 05 03:16 AM
Help adding text values Texas-DC_271 Excel Worksheet Functions 7 January 15th 05 11:14 PM


All times are GMT +1. The time now is 08:34 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"