Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding separate accumulators for multiple cells | New Users to Excel | |||
Format text across cells | New Users to Excel | |||
counting text cells | Excel Worksheet Functions | |||
Searching for text in cells | Excel Discussion (Misc queries) | |||
Help adding text values | Excel Worksheet Functions |