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?)
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.
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:
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.