LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
y y is offline
external usenet poster
 
Posts: 60
Default Concatenate a strings range.

CONCATENATE accepts only single cells.

How can I concatencate contiguos cells (a range of strings) without writing each cell reference by hand?

Only via VBA? And how?

Thank you Alex.

 
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
Concatenate strings? Alain Dekker Excel Discussion (Misc queries) 4 February 21st 10 08:51 PM
CONCATENATE I have two text strings in cells but it wont work paintsr Excel Discussion (Misc queries) 1 January 23rd 09 04:30 PM
strings in a range Peter Morris Excel Worksheet Functions 4 September 5th 06 01:00 AM
concatenate strings Gary''s Student Excel Worksheet Functions 3 September 15th 05 05:25 PM
space between text strings with concatenate Jeff Excel Discussion (Misc queries) 2 March 3rd 05 06:54 PM


All times are GMT +1. The time now is 02:45 PM.

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"