OZONE Asylum
Forums
OZONE
Excel Coding
This page's ID:
31079
Search
QuickChanges
Forums
FAQ
Archives
Register
Edit Post
Who can edit a post?
The poster and administrators may edit a post. The poster can only edit it for a short while after the initial post.
Your User Name:
Your Password:
Login Options:
Remember Me On This Computer
Your Text:
Insert Slimies »
Insert UBB Code »
Close
Last Tag
|
All Tags
UBB Help
Your example is unclear. Either the descriptions are concatenated to the left of the city name or they are in a list...it's one or the other. If you just want to concatenate descriptions this can be done very simply with formulas. I don't see any need for VBA unless your content is dynamic. For example, if the first description is in cell a2 and the second description is in cell a3 and you leave some space in between, it would be as simple as entering: [code]=a2&" "&a3[/code] you could add an if formula to check for blank rows. Nature & Travel Photography [url=http://www.sleepingwolves.com]Main Entrance[/url] [small](Edited by [url=http://www.ozoneasylum.com/user/6261]SleepingWolf[/url] on 06-29-2009 00:46)[/small]
Loading...
Options:
Enable Slimies
Enable Linkwords
« Backwards
—
Onwards »
Maximum Security
OZONE
DHTML/Javascript
Server-Side Scripting - Oh my!
CSS - DOM - XHTML - XML - XSL - XSLT
Stupid Basic HTML
Visual Therapy
Photoshop
Photoshop Pong, Anyone?
***WARNING*** BIG SIG APPROACHING
Photography
3D Modelling & Rendering
Multimedia/Animation
Print Graphics
Holding Pens
Philosophy and other Silliness
Outpatient Counseling
Site reviews!
Mad Scientists' Laboratory
Getting to know the Grail