DCSportbikes.net  
» Help Support .NET!
DCSportbikes Premier Membership for 25$ per year. Discounts! Click here for full information.

Now available in the .NET Shop:



Get your DCSBN Gear!
» Shoutbox
Sorry, only registered users have the ability to use our real-time shoutbox to chat with other members.

Register now, it's free!
» Online Users: 553
1 members and 552 guests
davidcycle
Most users ever online was 4,519, September 2, 2015 at 03:26 AM.
Go Back   DCSportbikes.net > Non-Sportbike Forums > Non-Sportbike Chat

Reply
LinkBack Thread Tools
Need some macro help -openoffice/word
Unread
  (#1)
TPG og
 
b00st's Avatar
 
Posts: 8,576
Join Date: October 9, 2008
Location: Hanover, PA
Need some macro help -openoffice/word - May 6, 2010, 08:01 PM

Well I tried, read tutorials. Cant figure this shiz out. I got 2 columns in Excel format (using open office). 1st column has first names, 2nd column has last names. I need to merge the 2 columns so have one single column with the first and last names together. Complication - theres 600+ names I need to merge. Pops is doing it for post prom and procrastinated and needs em asap. It works fine if I do one by one, highlight the 2 adjacent cells (1 cell first name, 1 cell last name), click Format, then merge. That works peachy. But I need to do it for all of them in mass. And when I tried highlighting all of them and merging, it turns into a mess and erases a whole crapton of everything.

Tried recording a macro, but need to it to do one merge, then move down a row and do the next but can't figure it out. Any IT peeps got any solutions?
  Send a message via AIM to Send a message via AIM to b00st  
Reply With Quote
Unread
  (#2)
Can't work my clutch!!
 
BigDaddyShoo's Avatar
 
Posts: 688
Join Date: July 5, 2008
Location: Centreville
May 6, 2010, 08:35 PM

place this in the third column directly to the right of first/last name columns

=concatenate(A1; B1)

this assumes that the first name is in column A, Row 1 and that the last name is column B, row 1.

then just copy it onto the next line and is should adjust it to read (A2; B2)

then copy those 2 into the next two lines and so on and so forth until it's copied onto all 600+ rows.
  Send a message via AIM to  
Reply With Quote
Unread
  (#3)
TPG og
 
b00st's Avatar
 
Posts: 8,576
Join Date: October 9, 2008
Location: Hanover, PA
May 6, 2010, 08:46 PM

AWESOME. Got it working somewhat, but it doesnt put a space inbetween the first and last names, just makes it one word. I'mma get cracking.

I seriously appreciate it brosef, owe ya big time.

Last edited by b00st; May 6, 2010 at 08:53 PM..
  Send a message via AIM to Send a message via AIM to b00st  
Reply With Quote
Unread
  (#4)
mac
V-Twin Junkie
 
mac's Avatar
 
Posts: 130
Join Date: April 2, 2010
Location: Herndon, VA
May 6, 2010, 08:56 PM

You can use this function instead to concatenate + add a space in between:

=A1&" "&B1

Will lead to "First Last" instead of concatenate's "FirstLast"

Good luck!

Also you can bulk apply your function by selecting your first row in column C having your function, CTRL+V to Copy, Then CTRL+SHIFT+END to go to end of worksheet, then Hit ENTER. This saves you from having to drag your function manually down 600 rows.


Work to ride and ride to work.

2003 SV1000
2001 GS500E
  Send a message via AIM to  
Reply With Quote
Unread
  (#5)
TPG og
 
b00st's Avatar
 
Posts: 8,576
Join Date: October 9, 2008
Location: Hanover, PA
May 6, 2010, 09:00 PM

SWEET BABY JEEBUS I GOT IT!!!

I owe both yall BBBBBBBIIIIIIIIGGGGGGG TIME!!!!!!!!!!!!!!!!! Thanks!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !
  Send a message via AIM to Send a message via AIM to b00st  
Reply With Quote
Unread
  (#6)
Your Ad Here
 
Heist's Avatar
 
Posts: 32,591
Join Date: August 25, 2008
Location: Washington, D.C.
May 6, 2010, 09:04 PM

Seeing this makes me remember how long its been since I've worked in Excel ...

And how much I've forgotten already.



“Any man who tries to be good all the time is bound to come to ruin among the great number who are not good. Hence a Prince who wants to keep his authority must learn how not to be good, and use that knowledge, or refrain from using it, as necessity requires”.

- Nicolo Machiavelli 1469-1527

  Facebook Page MySpace.com Page Send a message via AIM to  
Reply With Quote
Unread
  (#7)
TPG og
 
b00st's Avatar
 
Posts: 8,576
Join Date: October 9, 2008
Location: Hanover, PA
May 6, 2010, 09:11 PM

Quote:
Originally Posted by Heist View Post
Seeing this makes me remember how long its been since I've worked in Excel ...

And how much I've forgotten already.

haha yeah, I took classes in high school and college for office. them equations get tricky.

Big ups to shoo and mac, green dots for both yall. Buy ya brewskies if i ever meet yall.
  Send a message via AIM to Send a message via AIM to b00st  
Reply With Quote
Reply


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Powered by vBadvanced CMPS v3.2.3


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2019, vBulletin Solutions, Inc.
Search Engine Friendly URLs by vBSEO 3.6.0
vBulletin Skin developed by: vBStyles.com
All logos and trademarks in this site are property of their respective owner. The comments are property of their posters, all the rest © 2002-2010 by DCSportbikes.net. DCSportbikes.net is owned by End of Time Studios, LLC.