• AppleCentral Network:
  • Tech Support
  • |
  • Open Source
  • |
  • Apple News
  • |
  • Register Domains
  • |
  • SSL Certificates
  • |
  • iPod Deals
  • |
  • Mac Deals
  • |
  • Mac Book Shelf
  • AppleCentral Home
  • MacTech Magazine
    • About MacTech in Print
    • Issue Table of Contents
    • Subscribe
    • Risk Free Sample
    • Back Issues
    • MacTech DVD
    • MacTech Archives
    • MacTech Print Archives
    • MacMod
    • MacTutor
    • FrameWorks
    • develop
  • MacNews.com
    • MacNews News
    • Blog
    • MacTech Reviews and KoolTools
    • Whitepapers, Screencasts, Videos and Books
    • News Scanner
    • Rumors Scanner
    • Documentation Scanner
  • Apple Expo
    • by Category
    • by Company
    • by Product
  • MacForge.net
  • Job Board
  • Advertising
    • Benefits of MacTech
    • Mechanicals and Submission
    • Dates and Deadlines
    • Submit Apple Expo Entry
  • User
    • Register for Ongoing Raffles
    • Register new user
    • Edit User Settings
    • Logout
  • Contact
    • Customer Service
    • Webmaster Feedback
    • Submit News or PR
    • Suggest an article
  • Connect Tools
    • MacTech Live Podcast
    • RSS Feeds
    • Twitter
You are not logged in. [Log In] AppleCentral » Forums » Mac » Programming, Web Dev & Scripting » "Simple" script needed for MS Excel 2008
Register User    Forum List        Active Topics    FAQ
Topic Options
Hop to:
#548778 - 01/07/11 08:38 PM "Simple" script needed for MS Excel 2008
needtoknow Offline


Registered: 01/07/11
Posts: 4
Hello
I'm not sure if this is all that simple.

I was expecting to use macros when I found that my version of Excel does not support them. What I'm looking at it a piece of Apple Script that will do the following within the document:

I have a document with 1900 or so rows of information.
Each row has an address spread out in columns horizontally from left to right, 7 columns total, so A through G, starting with company name, contact name, address line 1 address line 2, city, state, zip.

What I need is to be able to do is consolidate the contents of all cells to the right of Row A in each row, to be placed under the contents of the Row A cell. I'm supposed to end up with an address block contained all in one cell. When all is said and done, I should have the same number of rows, but only one column.

My insane boss asked me to do this, not sure why he is not choosing some kind of database program which can arrange cells as fields, but he's doing the paying, and I hate to argue with him.

I have absolutely no programming experience whatsoever, and am looking for some help on this if possible (is it possible to do what I need with a piece of Apple Script?)

Thanks to anyone who can help,
needtoknow

Top
#548790 - 01/08/11 12:08 AM Re: "Simple" script needed for MS Excel 2008 [Re: needtoknow]
Reboot Offline

Muhahahaha

Registered: 04/22/02
Posts: 15046
Loc: Columbus OH
What version of Excel?
_________________________
AppleCentral Trivia

MM-MCF Trivia

Call the Doctor

Top
#548791 - 01/08/11 12:11 AM Re: "Simple" script needed for MS Excel 2008 [Re: Reboot]
MacBozo Offline
Nut Dood

Registered: 04/21/02
Posts: 17704
Loc: Pinellas Park, Florida
Originally Posted By: Reboot
What version of Excel?


The subject states it. Long day? laugh
_________________________

Top
#548800 - 01/08/11 01:45 AM Re: "Simple" script needed for MS Excel 2008 [Re: MacBozo]
Reboot Offline

Muhahahaha

Registered: 04/22/02
Posts: 15046
Loc: Columbus OH
dee dee dee blush

Yes, I hate when I have to actually work for a living, but it makes my creditors happy.

If the file is a delimited text file the poster can open it in Excel and do a concatenate of columns. Wonder if they'll stop back for that sage advice or is it a drive by. smirk
_________________________
AppleCentral Trivia

MM-MCF Trivia

Call the Doctor

Top
#548842 - 01/08/11 03:13 PM Re: "Simple" script needed for MS Excel 2008 [Re: Reboot]
needtoknow Offline


Registered: 01/07/11
Posts: 4
Not a drive by smile
I will report back... but it is originally an excel file

Top
#548844 - 01/08/11 03:59 PM Re: "Simple" script needed for MS Excel 2008 [Re: needtoknow]
Reboot Offline

Muhahahaha

Registered: 04/22/02
Posts: 15046
Loc: Columbus OH
Duck!!! j/k

If it's an Excel file in columns then you can just concatenate the columns with a Function under the Insert menu item.
_________________________
AppleCentral Trivia

MM-MCF Trivia

Call the Doctor

Top
#548917 - 01/09/11 09:53 PM Re: "Simple" script needed for MS Excel 2008 [Re: Reboot]
needtoknow Offline


Registered: 01/07/11
Posts: 4
Ok... I will try that.. have never really used functions before. Any tips or suggestions for someone doing this for the first time, or it's it self-explanatory as you do it?
Thank you so much by the way.. esp. considering my convoluted description of my issue.

Top
#548925 - 01/09/11 11:20 PM Re: "Simple" script needed for MS Excel 2008 [Re: needtoknow]
needtoknow Offline


Registered: 01/07/11
Posts: 4
OK... success!!! Thank you... a little reading and some experimenting and voila!

Wondering one final thing... do you know if it is possible to put a line break inserted between each cell field, within the conactenate function command?
Basically, my job is done if I can get the conactenated cell information to assemble vertically within the destination cell like a proper address block.
Otherwise put and with a visual aid:

A-1 is the destination cell. A-1 contains:

A-2 (COMPANY NAME)(line break)
B-2 (CONTACT)(line break)
C-2 (ADDRESS LINE 1)(line break)
D-2 (ADDRESS LINE 2)(line break)
E-2 (CITY)(line break)
F-2 (STATE)(line break)
G-2 (ZIP CODE)(line break)

(hyphens added just to separate the numbers and letters, I don't ref them that way in the prog.)

Top
Previous Topic
View All Topics Index
Next Topic

Tweet

Preview

Moderator:  Acumowchek, MacGizmo, Reboot 
Print Topic
Switch to Threaded Mode
Publications, Articles and Industry Discussion
   »MacTech/MacNews Article Discussions
   »Apple World
Marketplace
   »Deals and Special Offers
      »Expired Offers
   »Trading Warehouse
Mac
   »Hardware
   »Software
   »Servers, Security, and Networking
   »Programming, Web Dev & Scripting
   »Windows and Virtualization
   »Cloud and Online Services
Mobile Technologies
   »iPhone Apps, AppStore, and iTunes
   »iPad, iPhone, iPod and Apple TV Hardware
Mods and Hacks
   »General Mods
      »Techniques
      »Miscellaneous
      »Mod Logs
   »Laptop Mods
      »Case Mods
      »Hardware Mods
      »Misc. Mods
   »Desktop Mods
      »Case Mods
      »Hardware Mods
      »Misc. Mods
   »Peripheral Mods
      »iPod Mods
      »Misc Mods
   »Software Hacks & Mods
General Discussion
   »Site Feedback & Issues
   »Stan's Lounge
   »Soapbox
Now Software Support
   »Announcements
   »Now X
      »FAQs
      »Discussion
   »Now Up-to-Date & Contact
      »Community Help
      »Tips and tricks
View profile
Send a PM
Add to your Watched Users
View posts
View profile
Send a PM
Add to your Watched Users
View posts
View profile
Send a PM
Add to your Watched Users
View posts
View profile
Send a PM
Add to your Watched Users
View posts
View profile
Send a PM
Add to your Watched Users
View posts
View profile
Send a PM
Add to your Watched Users
View posts
View profile
Send a PM
Add to your Watched Users
View posts
View profile
Send a PM
Add to your Watched Users
View posts
Board Rules · Mark all read
Contact Us · AppleCentral · Top

MacTech Only Search:
Community Search:

 
 
 

 
 
 
 
 
  • SPREAD THE WORD:
  • Slashdot
  • Digg
  • Del.icio.us
  • Reddit
  • Newsvine
  • Generate a short URL for this page:



AppleCentral. www.applecentral.com
Main office: 805-494-9797
Xplain's use of MacNews, AppleCentral and AppleExpo are not affiliated with Apple, Inc. MacTech is a registered trademark of Xplain Corporation. AppleCentral, MacNews, Xplain, "The journal of Apple technology", Apple Expo, Explain It, MacDev, MacDev-1, THINK Reference, NetProfessional, MacTech Central, MacTech Domains, MacForge, and the MacTutorMan are trademarks or service marks of Xplain Corp. Sprocket is a registered trademark of eSprocket Corp. Other trademarks and copyrights appearing in this printing or software remain the property of their respective holders.
All contents are Copyright 1984-2010 by Xplain Corporation. All rights reserved. Theme designed by Icreon.
Generated in 0.040 seconds in which 0.025 seconds were spent on a total of 13 queries. Zlib compression enabled.
Powered by UBB.threads™ PHP Forum Software 7.5.8