Solved: Open Office/Excel - Macro Help
Your cache administrator is webmaster. No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers This would be an example... =MCONCAT(A1:G1," ") ...where A1:G1 is the range of cells you want to concatenate, and you want to delimit it by a space between each cells value. For Excel, select A2:J2, click in the formula bar, paste this: =MID($A$1,((ROW()-2)*10)+COLUMN(),1) and press CTRL+Enter. check over here
I lost my OpenSource virginity! Advertisement Recent Posts Good Ideas! Knowledge management and the paperless office Toolbox for IT My Home Topics People Companies Jobs White Paper Library Collaboration Tools Discussion Groups Blogs Follow Toolbox.com Toolbox for IT on Twitter Toolbox.com Advertisement Tech Support Guy Home Forums > Software & Hardware > Business Applications > Home Forums Forums Quick Links Search Forums Recent Posts Members Members Quick Links Notable Members Current Visitors https://forum.openoffice.org/en/forum/viewtopic.php?f=9&t=79843
I'm at school at the moment but as soon as I get home I'll try it. The system returned: (22) Invalid argument The remote host or network may be down. I ended my career in BASIC in 1978. Top White Papers and Webcasts Popular Five IT Mistakes to Avoid: Expert Insight on Determining ...
Join over 733,556 other people just like you! Please let me know if anyone knows a good solution out there. For example, if I pasted this paragraph into cell A1 then click my macro, this happens (edit: doesn't matter what case the letters come out in; caps or as they were There should be no data to the right of the cell you wish to perform this on.
You're now being signed in. You can use a space character as the delimiter and it will put each word into it's own cell. Please try the request again. http://ooo-forums.apache.org/en/forum/viewtopic.php?f=20&t=42544 Home | Invite Peers | More Linux Groups Your account is ready.
Board index The team • Delete all board cookies • All times are UTC + 1 hour [ DST ] Forum powered by phpBB © phpBB Group By any use of For getting all of the information into one cell, you should download/install the morefunc.xll add-in by Laurent Longre (a google search will lead you there), and then you can use the Style Default Style Contact Us Help Home Top RSS Terms and Rules Copyright © TechGuy, Inc. Top Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving...
Log In E-mail or User ID Password Keep me signed in Recover Password Create an Account Blogs Discussions CHOOSE A TOPIC Business Intelligence C Languages Cloud Computing Communications Technology CRM Bonuses If you come across a DES ('Dead End Street') ask the open source developers of BrOffice about your problem. Short URL to this thread: https://techguy.org/820100 Log in with Facebook Log in with Twitter Log in with Google Your name or email address: Do you already have an account? Edits are subject to review by community moderators.
EDIT2: The formula CONCATENATE(a1;b1;c1) etc seems to work for the opposite, except for the fact that i'm working with strings 1000 characters long, and CONCATENATE(a1:z100) or whatever doesn't work, it just http://sumolinux.com/solved-open/solved-open-office-pdf-problems.html William Acree replied Oct 22, 2010 The VBA interoperability project is the only tool from VBA on open source spreadsheet systems that I am aware of. Show Ignored Content As Seen On Welcome to Tech Support Guy! If you want it to span less/more columns, just adjust *10.
Thanks. Click here to join today! Tech Support Guy is completely free -- paid for by advertisers and donations. http://sumolinux.com/solved-open/solved-open-office.html Thanks!
PCMag Digital Group AdChoices unused ERROR The requested URL could not be retrieved The following error was encountered while trying to retrieve the URL: http://0.0.0.10/ Connection to 0.0.0.10 failed. Always respect the original author. JudeWright, Apr 20, 2009 #4 bomb #21 Joined: Jul 1, 2005 Messages: 8,310 From the download page: "These functions are compatible with Excel 95 to 2007.
ekim68 replied Mar 6, 2017 at 11:14 PM Sign of the times ekim68 replied Mar 6, 2017 at 11:12 PM Cool stuff on YouTube #2 ekim68 replied Mar 6, 2017 at
Board index The team • Delete all board cookies • All times are UTC + 1 hour [ DST ] Forum powered by phpBB © phpBB Group By any use of If you're not already familiar with forums, watch our Welcome Guide to get started. Are you looking for the solution to your computer problem? Regards --- Help the community by fixing grammatical or spelling errors, summarizing or clarifying the solution, and adding supporting information or resources.
In BrOffice.org Spreadsheet open from the menu: Help -> About BrOffice.org You will find an e-mail for contacts there. HTH bomb #21, Apr 20, 2009 #3 JudeWright Thread Starter Joined: Apr 19, 2009 Messages: 2 Thank you very much! Related Deploy a dynamic, services-oriented cloud for your business Forrester Consulting Report: Empowered Customers Drive ... 7 Stages of IT Monitoring Grief MoreWhitePapers Best Answer 0 Mark this reply as the have a peek at these guys Thilina Randombage replied Oct 22, 2010 @Christo: I need to be able to run macros on Excel (VBA code) using the opensource alternative as well. @Jalal and @William: Yes.
If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.