excel question - Computer Technical Help - Software and Hardware Forum

Two Plus Two Forums Other Topics Computer and Technical Help

excel question

Post Reply Subscribe

...

04-10-2017 , 05:47 AM

I bet

stranger

Join Date: Apr 2017 Posts: 3

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?

Quote

04-10-2017 , 08:06 AM

thunderbolts

Pooh-Bah

Join Date: Aug 2008 Posts: 3,596

Does this help?

Quote

04-10-2017 , 09:30 AM

Gabethebabe

Malware Jedi

Join Date: Oct 2007 Posts: 27,387

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

Quote

04-10-2017 , 10:13 AM

kerowo

lolcat

Join Date: Nov 2005 Posts: 37,190

10 to 1 this is a spam set up.

Quote

04-10-2017 , 12:15 PM

I bet

stranger

Join Date: Apr 2017 Posts: 3

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.

Quote

04-10-2017 , 01:54 PM

Jeremy517

Carpal \'Tunnel

Join Date: Jul 2004 Posts: 7,022

Quote:

Originally Posted by I bet

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,"]")

Quote

04-11-2017 , 02:24 AM

Gabethebabe

Malware Jedi

Join Date: Oct 2007 Posts: 27,387

Quote:

Originally Posted by kerowo

10 to 1 this is a spam set up.

Well, he took the time to make up a good alias, not sp4mb0t5734, for example

Quote

04-11-2017 , 03:23 AM

I bet

stranger

Join Date: Apr 2017 Posts: 3

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

TY guys

Quote

04-20-2017 , 09:44 PM

rivercitybirdie

Pooh-Bah

Join Date: May 2012 Posts: 4,707

Quote:

Originally Posted by Jeremy517

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.

Quote

04-20-2017 , 09:50 PM

#10

rivercitybirdie

Pooh-Bah

Join Date: May 2012 Posts: 4,707

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.

Quote

Post Reply Subscribe

...