Two Plus Two Publishing LLC Two Plus Two Publishing LLC
 

Go Back   Two Plus Two Poker Forums > >

Notices

Computer Technical Help Post your questions about computer hardware and software and configuring same here.

Reply
 
Thread Tools Display Modes
Old 04-10-2017, 05:47 AM   #1
I bet
stranger
 
Join Date: Apr 2017
Posts: 3
excel question

When I copy and paste how would I go about combining the columns together, for example in the first picture the first column displays name SHOWTIME, second column number 21, and next column displays 57k




But how would I combine them together instead so they display all the values in the same column like this?

I bet is offline   Reply With Quote
Old 04-10-2017, 08:06 AM   #2
thunderbolts
veteran
 
thunderbolts's Avatar
 
Join Date: Aug 2008
Posts: 3,363
Re: excel question

Does this help?
thunderbolts is offline   Reply With Quote
Old 04-10-2017, 09:30 AM   #3
Gabethebabe
Malware Jedi
 
Gabethebabe's Avatar
 
Join Date: Oct 2007
Location: In front of my monitor
Posts: 21,152
Re: excel question

Assume SHOWTIME = cell I1

Put a formula

=I1&J1&K1

If you want spaces in between
=I1&" "&J1&" "&K1

Also

=Concatenate(I1,J1,K1)

would work
Gabethebabe is offline   Reply With Quote
Old 04-10-2017, 10:13 AM   #4
kerowo
lolcat
 
kerowo's Avatar
 
Join Date: Nov 2005
Posts: 32,229
Re: excel question

10 to 1 this is a spam set up.
kerowo is online now   Reply With Quote
Old 04-10-2017, 12:15 PM   #5
I bet
stranger
 
Join Date: Apr 2017
Posts: 3
Re: excel question

Thanks guys, much appreciated!! and nah no spam.

Say If I went to add brackets around the number or word how would I do that? for example adding brackets around the number 21 etc like in pic below.

I bet is offline   Reply With Quote
Old 04-10-2017, 01:54 PM   #6
Jeremy517
Pooh-Bah
 
Join Date: Jul 2004
Posts: 5,800
Re: excel question

Quote:
Originally Posted by I bet View Post
Thanks guys, much appreciated!! and nah no spam.

Say If I went to add brackets around the number or word how would I do that? for example adding brackets around the number 21 etc like in pic below.

Just add strings to your concatenate:

=Concatenate("[",I1,J1,K1,"]")
Jeremy517 is offline   Reply With Quote
Old 04-11-2017, 02:24 AM   #7
Gabethebabe
Malware Jedi
 
Gabethebabe's Avatar
 
Join Date: Oct 2007
Location: In front of my monitor
Posts: 21,152
Re: excel question

Quote:
Originally Posted by kerowo View Post
10 to 1 this is a spam set up.
Well, he took the time to make up a good alias, not sp4mb0t5734, for example
Gabethebabe is offline   Reply With Quote
Old 04-11-2017, 03:23 AM   #8
I bet
stranger
 
Join Date: Apr 2017
Posts: 3
Re: excel question




=(I1&" ("&J1&") "&K1)


TY guys
I bet is offline   Reply With Quote
Old 04-20-2017, 09:44 PM   #9
rivercitybirdie
veteran
 
Join Date: May 2012
Posts: 2,877
Re: excel question

Quote:
Originally Posted by Jeremy517 View Post
Just add strings to your concatenate:

=Concatenate("[",I1,J1,K1,"]")
i need to learn advanced formulae like the above..... oops, maybe it's not as advanced as i thought......... but i'm thinking arrays and things like summing a column when it includes a bunch of error cells. basic summing gives you an error.
rivercitybirdie is offline   Reply With Quote
Old 04-20-2017, 09:50 PM   #10
rivercitybirdie
veteran
 
Join Date: May 2012
Posts: 2,877
Re: excel question

not sure it relates directly to your question.......... but i've needed to use TEXT and STRING functions sometimes. converting numbers to text and vice-versa. or at least getting excel to recognize something as a number when you've scraped it from a website.
rivercitybirdie is offline   Reply With Quote

Reply
      

Thread Tools
Display Modes

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


Forum Jump


All times are GMT -4. The time now is 07:22 PM.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Search Engine Optimisation provided by DragonByte SEO v2.0.33 (Pro) - vBulletin Mods & Addons Copyright © 2017 DragonByte Technologies Ltd.
Copyright ę 2008-2010, Two Plus Two Interactive
 
 
Poker Players - Streaming Live Online