Added Chapters for everyone's viewing pleasure. I realize that I used to talk way too much in my older videos because I focused too much on the why instead of jumping to the how. If you want to skip straight to the formula, head to the second chapter starting at 2:12. Enjoy!
What does the formula in your first cell look like? And you're using the autofill dot in the corner, right? Not sure where you're seeing a dropdown arrow.
Hi, I hava a que, Could you please help me with that. Can we take first 2 letter of A1 and first 3 letter of B2. and combine it This is how result should looks like = Josmi
You can use the "left" formula for that. So your formula would look something like this: =LEFT(A1,2) & LEFT(B1,3) That games the first 2 characters of A1 and first 3 of B1. You can see the tutorial on the len, left, mid, and right formulas here: www.easyprogramming.net/exceltutorials/len_right_left_mid.php You can also get the example file from that. Good luck!
THAT WAS so helpful. but this is my problem: after I combine the first name (column A) and last name (column B) into the full name (column C) , when i try to delete the first two columns (A & B ) column C gets deleted. what am i missing! thanks in advance for answering.
When you are autofilling, instead of dragging, double click on the little square dot at the bottom right. It should fill all the way down. I demo around minute 9:00 of the auto fill tutorial here: ruclips.net/video/4_t9EMXACZQ/видео.html
if you keep the reference and delete the column, then the cell will break. If you want to keep that data and remove the reference column, you should copy your newly concatenated cell and paste it right onto it self as value. If you right-click, under paste, you should see a few options that say "paste as value" - once you do that, the formula will be gone and you can delete the reference columns.
hello again. I saw a similar question and your solution for deleting the reference columns after concatenation but after trying it, the columns still were either duplicated or deleted. is there a video explanation of how to do it? thanks in advance. you are really great.
You can use the concat formula like this: =concat(a1:z1) and it'll concatenate that whole row. But you won't be able to add spaces there unless you have cells in your range with spaces.
If I understand correctly then you can do something like this = "(" & B1 & ")" If B1 value is RUclips then the output for that would look like this: (RUclips)
how do i combine two columns but maintain margin ( data length in both column is not fix, still i want the that the resulting column should have all the second columns data starting from the same space / margin - can any one help on this plz TC
I haven't used MS Access is maybe 8 years. I know there's a concat method you can use when you query. Check this out here: www.techonthenet.com/access/functions/string/concat.php
I just tested this and I was able to concatenate. What does your data look like? Is it just text in one column and number in another? Or do you have formulas?
Thanks a lot for updating this...it help me savibg lot of time..but one query what if i want to combine from three cells and want to put comma to seprate
Assuming your data is in A1, B1, and C1, you can do something like this: =A1&", "&B1&", "&C1 That'll add a comma and a space, if you don't want the space just get rid of it in the quotes. Hope that helps!
If you want to merge the cells, the easiest thing to do would be copy all of your concatenated data, and then paste as value (right click -> paste as value). That will get rid of the concatenation formula but your data will remain unaffected.
You should copy that new column and paste it as text only. If you copy it, right click, you'll see options to "paste as value" or something like that. If you do that, then you can remove the original cells. Otherwise you'll get a reference error.
well when I drag it down the only name will fill is the name on the first line. Ex. on your video, if I drag it down, the autofill will only pit John Smith. How can I fix this? Thanks :)
After you drag it down and it copies the first line, can you click into the second cell and look at the formula and share it here. I wonder if for some reason it's using an absolute reference.
Good question! You can concatenate those around the last name. So if first name is in cell A1 and last name is in cell B1, you can do something like this: =A1 & " (" & B1 & ")" There's a space before the first open parenthesis. Hope this helps!
Hey there, I just tested it and it still works. What result are you seeing when you try? You can also try the concatenate function, your example above would translate to this: =CONCATENATE(C6,"-",G6) Good luck!
By pairing two cells, do you mean, the value of one determines the value of another? E.g. if cell A1 is "Bob" then cell "B2" will do a lookup and put the value associated with Bob? If so, you're looking for a lookup formula. There are a few types, the most common is vlookup. The second is Index/Match - it's a bit harder but much better than vlookup. And then there's xlookup which is new and better than the previous two but not every version of Excel has it. I think only the latest version and O365 have it. I have tutorials on all three linked below. The pages also have a link to the examples I use in the video at the bottom of the page: VLOOKUP: www.easyprogramming.net/exceltutorials/vlookup_function.php INDEX/MATCH: www.easyprogramming.net/exceltutorials/index_match_function.php XLOOKUP: www.easyprogramming.net/exceltutorials/xlookup.php Also have a bigger example that turns excel into a type of "order form": www.easyprogramming.net/exceltutorials/create_simple_order_form.php Hope this helps! You can find more info on the above three formulas with a quick google search.
Thanks for the feedback. I'll admit my older videos weren't as organized but I try to focus on the 'why' as well as the 'how' so my videos tend to be more wordy. I also use a lot of analogies because the videos are meant to be for beginners and all those words add up. Sorry for the lengthy video! Thanks for watching!
I know bro. I do have a pinned comment explaining why. I used to teach Excel in a classroom and found it helpful to talk about the "why" more than the "how" so I unintentionally transferred that into my older videos. Newer videos are more on point but I still try to focus on the why because I think it's important.
What do I do if I need the function on different lines in the same box, like in your example I would need John “alt enter” smith? Smith being on a new line but still in the same cell? Thanks
First enable "Wrap Text" for that cell, then you can concatentate "CHAR(10)" anywhere you want a line break. For Example to enter a line break between A1 and B1, you'd do: =A1 & CHAR(10) &B1 This only works if you have "Wrap Text" enabled for that cell.
Nazmus Nasir One more question. The number that I type in needs to have decimal places. And when it goes through the function and adds in a letter (z-3.0) it looses the .0 and just reads (z-3) the increase decimal button isn’t working because of the letter z in the box. I’m using this to generate code for a Cnc machine and it needs to read z-3.0
@@trace12345678900You can convert the the 3.0 to a text within the formula and add the .0 like this: =A2&"-"&TEXT(B2,"#.0") Assuming B2 is where your 3.0 is.
You can set up conditional formatting to get different colors based on variable (assuming that's what you are looking to do). You can see the tutorial here: www.easyprogramming.net/exceltutorials/conditional_formatting.php You can also download the example file on that page so you can go straight to the formula.
Hi Sir I have droughts on Vlook if have multiple same numbers but value taken for only one like A have 1 no and again A have 2 no so when i take vlookup for A its taken 1 no only for two different cells.can you please help here.
Are you trying to get both numbers? What does your formula look like? Vlookup will normally get the first value that it matches so it makes sense why you are seeing just one.
Hey Rebecca, The trick I normally use is to copy the new column and paste it back as just values. If you right click and paste, you'll get a bunch of options. You'll want one that just pastes values. Then you can get rid of the first two columns.
You just want to copy two cells from sheet 1 into sheet 2? It'll work the same way, in sheet 2, start with the equal sign to start the formula, head to sheet1 and select your cells. It'll end up looking something like this: =Sheet1!A1&" "&Sheet1!A50
I want to concatenate using IF statement (only when the second cell has value and i can do it easily), but in my condition, the second cell has comma-separated values and I want to concatenate one cell value with every comma-separated value in the second cell. Can you help me in this condition without using text to column function as my data is large and cant handle several columns. For example cell 1: A cell 2: B,C,D Desired output: AB,AC,AD
You may be able to do that with VB more easily. With just basic excel formulas, you'd have to combine a whole bunch formulas to do so. The easiest solution may be to split your comma-separated values into different cells and then concatenate them in a 4th cell. It would give you more control and probably look neater. Otherwise I found this article that may help you: exceljet.net/formula/split-text-with-delimiter That shows you how to split values with a delimiter, you can use it in combination with this concatenation tutorial to get the result you're looking for.
If you right click, you should have paste options where you can select to paste the formula or data. If you hover over the options, it'll tell you what it'll paste.
Really helpful and too the point thanks. I needed this due to my fantasy excel page that I am working on the site I am using seperated the names just as you said and it messed with the book I was working again thanks
If you're copying from word and they're being listed in one column, you can copy that column again and then paste as transpose. When pasting, if you right-click, the 4th paste option should say "Transpose" - this will take your rows and paste them as different columns. Hope that helps!
I don't have a Mac to test on. So I'm wondering if that's a mac only issue. I tried a couple other times, haven't been able to replicate it on my windows machine.
Thanks for the feedback. I'll admit my older videos weren't as organized but I try to focus on the 'why' as well as the 'how' so my videos tend to be more wordy. I also use a lot of analogies because the videos are meant to be for beginners and all those words add up. Thanks for watching!
Something like this should work: =A1&":"&B1 You can add your own text inside the quotes. I put a space in the video but you can replace it with a colon.
Yes but if you use this method, it'll turn the numbers into text values and you won't be able to do calculations. If that's not a concern, then it will work exactly the same.
Thank you! I think the kind of language you want to learn depends on what you want to do. For beginners, I usually recommend starting off with JavaScript because it's really easy to get started. You don't need any kind of IDE and can just run it on your browser as-is. I also have 56 tutorials on JS here: www.easyprogramming.net/javascript.php Python is also a popular language to start with, especially if you are into data science. I'd also recommend reading up on algorithms and data structures in general as they will be helpful down the line. Once you learn one language, it's pretty easy to move onto others. And it's also okay to start a language and move onto something else if you don't like it. Best of luck!
Are you referring to autofill? I have a tutorial that covers autofill here: www.easyprogramming.net/exceltutorials/autofill_excel.php I show you how to drag any function all the way by dragging or double clicking. Starts around the 9:00 minute mark.
When I copy and paste your formula, your quotes are 2 single quotes so it fails, Can you switch it to double quotes instead? You can copy and paste this: =D327&" "&E327
@@Akhan1999 I meant the apostrophes like this: ' I'm too used to programming speak. Apostrophes are called single quotes and regular quotation marks are double quotes.
Thanks for the feedback. I'll admit my older videos weren't as organized but I try to focus on the 'why' as well as the 'how' so my videos tend to be more wordy. I also use a lot of analogies because the videos are meant to be for beginners and all those words add up. Thanks for listening!
Are you going to make a new cell or are you trying to merge A1 into B1? If the latter, then you can't do it without overriding one of the values. If you're making a new Cell and you're in the same column (let's say A1 and A2) then just do =A1&A2 into your new cell. Then you can copy that into whichever cell you'd like. Hope this helps!
Sir 1 thing more i want to ask i hope u'll help me...i have emails and names in 1 column example:A1=JOHN A2=EMAIL, A3=ALI AND A4= EMAIL and countinous...means in same coulum firstly name and then their e-mail sir how i copy their names and paste in front of email...?they are thousand male its hard to copy one by one
@@attiqurrehman6134 That's a tough one. There could be a few ways to do it and one that comes to the top of my head is doing a formula like this: =A1&A2 Then you autofill all the way down. This will make all Even numbered rows wrong. You can then select all Even Number Rows and remove them. You can also set up a filter by creating a third column with this formula: =ISEVEN(ROW(A1)) That means if the row is an "odd" number like A1, it'll be "FALSE" otherwise it'll be 'TRUE' - you can then select all TRUE values and filter them out. Let me know if this helps in any way. It's a couple more steps but I think this would be the easiest path for you.
@@naztronaut hye, thanks for information...sir, if i send u a screenshot then u can understand better and there'll be more beneficial for me if u make a video on it....sir if u done this than i'll be very thankful for your help & sir u can save my time...its request
@@attiqurrehman6134 I wish I had time to make these videos. Sadly I don't think I'll be making any more Excel videos anytime soon and no videos until early 2020 at this point.
Thanks for the feedback. I'll admit my older videos weren't as organized but I try to focus on the 'why' as well as the 'how' so my videos tend to be more wordy. I also use a lot of analogies because the videos are meant to be for beginners. Thanks for listening!
I'll admit my older videos weren't as organized as I tried to focus on the 'why' as well as the 'how' so my videos tend to be more wordy. I also use a lot of analogies because the videos are meant to be for beginners and all those words add up. Thanks for listening!
Added Chapters for everyone's viewing pleasure. I realize that I used to talk way too much in my older videos because I focused too much on the why instead of jumping to the how. If you want to skip straight to the formula, head to the second chapter starting at 2:12.
Enjoy!
Bro.... 2:00 in and you still haven't gotten to the point. OmG
Right!
Have been looking for this comment.
Please start your own channel.
same :(
I was about to go crazy, making my list. Thanks so much for your tutorial. You made it clear and very easy to navigate! :)
Glad this was helpful :)
Video Start 2:20
Thanks bro
The drop down arrow keep copying tje first concatenation and not the later cells
What does the formula in your first cell look like? And you're using the autofill dot in the corner, right? Not sure where you're seeing a dropdown arrow.
Hi,
I hava a que, Could you please help me with that.
Can we take first 2 letter of A1 and first 3 letter of B2. and combine it
This is how result should looks like = Josmi
You can use the "left" formula for that. So your formula would look something like this:
=LEFT(A1,2) & LEFT(B1,3)
That games the first 2 characters of A1 and first 3 of B1. You can see the tutorial on the len, left, mid, and right formulas here: www.easyprogramming.net/exceltutorials/len_right_left_mid.php
You can also get the example file from that. Good luck!
THAT WAS so helpful. but this is my problem: after I combine the first name (column A) and last name (column B) into the full name (column C) , when i try to delete the first two columns (A & B ) column C gets deleted. what am i missing! thanks in advance for answering.
i have a list of 500,000, without draggin the formula all the way down, is there a way to do it, for all 500k
When you are autofilling, instead of dragging, double click on the little square dot at the bottom right. It should fill all the way down. I demo around minute 9:00 of the auto fill tutorial here: ruclips.net/video/4_t9EMXACZQ/видео.html
just found a video showing what you described. and it worked. so thank you again so much!
Hey Ellen, sorry for the delay, glad you were able to find a solution!
After concatenation can we delete the reference columns??
if you keep the reference and delete the column, then the cell will break. If you want to keep that data and remove the reference column, you should copy your newly concatenated cell and paste it right onto it self as value.
If you right-click, under paste, you should see a few options that say "paste as value" - once you do that, the formula will be gone and you can delete the reference columns.
Thank you for sharing this code. it will help me doing my job faster.Appreciated. Thanks again.
hello again. I saw a similar question and your solution for deleting the reference columns after concatenation but after trying it, the columns still were either duplicated or deleted. is there a video explanation of how to do it? thanks in advance. you are really great.
Thnks A Lot
Thank you so much
Let's say I had some 150 columns, how would I do that the easiest way possible? (without having to type it all out, A1, B1, C1, etc..)
You can use the concat formula like this:
=concat(a1:z1) and it'll concatenate that whole row. But you won't be able to add spaces there unless you have cells in your range with spaces.
How to put to numbers or % value in one cell
Can you clarify a bit more? Do you want to format the cell to be a number? Concatenations mostly work with strings.
here example in Is possible for B1 cell value/name open & close brackets ? Ex: (B1)
If I understand correctly then you can do something like this
= "(" & B1 & ")"
If B1 value is RUclips then the output for that would look like this: (RUclips)
how do i combine two columns but maintain margin ( data length in both column is not fix, still i want the that the resulting column should have all the second columns data starting from the same space / margin - can any one help on this plz TC
How to combine it in MS Access
I haven't used MS Access is maybe 8 years. I know there's a concat method you can use when you query. Check this out here: www.techonthenet.com/access/functions/string/concat.php
Thank you
Thank you
Thank you
HOW Do you merge cells that have days of the week in one column, and numbers in the second column? the concatenation rule isn't working.
I just tested this and I was able to concatenate. What does your data look like? Is it just text in one column and number in another? Or do you have formulas?
Thanks a lot for updating this...it help me savibg lot of time..but one query what if i want to combine from three cells and want to put comma to seprate
Assuming your data is in A1, B1, and C1, you can do something like this:
=A1&", "&B1&", "&C1
That'll add a comma and a space, if you don't want the space just get rid of it in the quotes. Hope that helps!
Superbbbbbbbbbbbbbbbbbbbbb
thanks
Thank you
After adding the 2 columns.........Not possible to copy the text which we have added the 2 columns (showing formula not data)
If you right click on the cell, and paste values only, it'll paste the values instead of the formula.
Thanks for sharing. What if i have to merge cell but to put a value under first one. Like
John
Smith
If you want to merge the cells, the easiest thing to do would be copy all of your concatenated data, and then paste as value (right click -> paste as value). That will get rid of the concatenation formula but your data will remain unaffected.
Thank you! This was very helpful. Can I remove the original cells now that I have combined into one?
You should copy that new column and paste it as text only. If you copy it, right click, you'll see options to "paste as value" or something like that. If you do that, then you can remove the original cells. Otherwise you'll get a reference error.
well when I drag it down the only name will fill is the name on the first line. Ex. on your video, if I drag it down, the autofill will only pit John Smith. How can I fix this? Thanks :)
After you drag it down and it copies the first line, can you click into the second cell and look at the formula and share it here. I wonder if for some reason it's using an absolute reference.
Excellent. Thank you :)
Great thanks - what if you want the 2nd word in parenthesis? i.e. John (Smith) And thank you!
Daniel
Good question! You can concatenate those around the last name. So if first name is in cell A1 and last name is in cell B1, you can do something like this:
=A1 & " (" & B1 & ")"
There's a space before the first open parenthesis. Hope this helps!
Thanks bro really helpful
=C6&"-"&G6
Pretty sure this changed at some point?? idk this doesnt work for me, thinkn i gotta learn how 'concat' works
Hey there, I just tested it and it still works. What result are you seeing when you try?
You can also try the concatenate function, your example above would translate to this:
=CONCATENATE(C6,"-",G6)
Good luck!
I figured it out, tried it on a new document and it works. Something with the number format from where I copied the data was messing it up.
@@FenixDown147 Ah glad you figured it out!
Hi thanks for the video do you know how to pair 2 cell? Its for a leader table where I want the name and score to always be inline
By pairing two cells, do you mean, the value of one determines the value of another? E.g. if cell A1 is "Bob" then cell "B2" will do a lookup and put the value associated with Bob?
If so, you're looking for a lookup formula. There are a few types, the most common is vlookup. The second is Index/Match - it's a bit harder but much better than vlookup. And then there's xlookup which is new and better than the previous two but not every version of Excel has it. I think only the latest version and O365 have it.
I have tutorials on all three linked below. The pages also have a link to the examples I use in the video at the bottom of the page:
VLOOKUP: www.easyprogramming.net/exceltutorials/vlookup_function.php
INDEX/MATCH: www.easyprogramming.net/exceltutorials/index_match_function.php
XLOOKUP: www.easyprogramming.net/exceltutorials/xlookup.php
Also have a bigger example that turns excel into a type of "order form": www.easyprogramming.net/exceltutorials/create_simple_order_form.php
Hope this helps! You can find more info on the above three formulas with a quick google search.
Good tutorials but you talk too much.
Thanks for the feedback. I'll admit my older videos weren't as organized but I try to focus on the 'why' as well as the 'how' so my videos tend to be more wordy. I also use a lot of analogies because the videos are meant to be for beginners and all those words add up.
Sorry for the lengthy video!
Thanks for watching!
@@naztronaut Thank you too for your time to do this for all of us to improve.
I don’t know a lot about Excel but damn bro you took 5 minutes to do something. This could’ve been a 2 minute video -.-
I know bro. I do have a pinned comment explaining why. I used to teach Excel in a classroom and found it helpful to talk about the "why" more than the "how" so I unintentionally transferred that into my older videos. Newer videos are more on point but I still try to focus on the why because I think it's important.
very helpful. thank you so much
Thank you sir.its used my task
How do I delete the 3 cells whilst maintaining the information in the new cell?
Thanks for huge support...👏👏👏
What do I do if I need the function on different lines in the same box, like in your example I would need John “alt enter” smith? Smith being on a new line but still in the same cell? Thanks
First enable "Wrap Text" for that cell, then you can concatentate "CHAR(10)" anywhere you want a line break. For Example to enter a line break between A1 and B1, you'd do:
=A1 & CHAR(10) &B1
This only works if you have "Wrap Text" enabled for that cell.
Nazmus Nasir Thanks for the reply! That worked for what I needed. 👍🏽
Nazmus Nasir One more question. The number that I type in needs to have decimal places. And when it goes through the function and adds in a letter (z-3.0) it looses the .0 and just reads (z-3) the increase decimal button isn’t working because of the letter z in the box. I’m using this to generate code for a Cnc machine and it needs to read z-3.0
@@trace12345678900You can convert the the 3.0 to a text within the formula and add the .0 like this:
=A2&"-"&TEXT(B2,"#.0")
Assuming B2 is where your 3.0 is.
This is quite helpful, keep it up Sir.
WOW YOU ARE AMAZING THIS IS SO EASY I HAVE 150 STUDENTS I NEEDED TO MERGE NAMES FOR!! THANKYOUUU
Glad it was helpful :)
Can you help using a formula to highlight cells into a different colour
You can set up conditional formatting to get different colors based on variable (assuming that's what you are looking to do). You can see the tutorial here: www.easyprogramming.net/exceltutorials/conditional_formatting.php
You can also download the example file on that page so you can go straight to the formula.
Thank you so much needed this
Hi Sir I have droughts on Vlook if have multiple same numbers but value taken for only one like A have 1 no and again A have 2 no so when i take vlookup for A its taken 1 no only for two different cells.can you please help here.
Are you trying to get both numbers? What does your formula look like? Vlookup will normally get the first value that it matches so it makes sense why you are seeing just one.
Also realized that this isn't my vlookup tutorial, check that out here: www.easyprogramming.net/exceltutorials/vlookup_function.php
Question, how can I keep the merge as it’s shown together and delete the first two columns
Hey Rebecca,
The trick I normally use is to copy the new column and paste it back as just values. If you right click and paste, you'll get a bunch of options. You'll want one that just pastes values. Then you can get rid of the first two columns.
How about copy last and first from sheet 1 to sheet 2 putting to 1 column.
You just want to copy two cells from sheet 1 into sheet 2?
It'll work the same way, in sheet 2, start with the equal sign to start the formula, head to sheet1 and select your cells. It'll end up looking something like this:
=Sheet1!A1&" "&Sheet1!A50
Quality just what I needed
Holy moly, thanks a lot! It's like magic.
that was great!!! was really amazed!!!
You are my hero!! Really needed this
Time saver! Thank you
I want to concatenate using IF statement (only when the second cell has value and i can do it easily), but in my condition, the second cell has comma-separated values and I want to concatenate one cell value with every comma-separated value in the second cell. Can you help me in this condition without using text to column function as my data is large and cant handle several columns.
For example
cell 1: A
cell 2: B,C,D
Desired output: AB,AC,AD
You may be able to do that with VB more easily. With just basic excel formulas, you'd have to combine a whole bunch formulas to do so. The easiest solution may be to split your comma-separated values into different cells and then concatenate them in a 4th cell. It would give you more control and probably look neater.
Otherwise I found this article that may help you: exceljet.net/formula/split-text-with-delimiter
That shows you how to split values with a delimiter, you can use it in combination with this concatenation tutorial to get the result you're looking for.
Thank You!
THANK YOU
What would I do if I want a+b and c be the total I had the rule and lost it
Are you talking about just adding numbers of concatenating them? Can you provide an example?
I get only formula.. while i copy the data
If you right click, you should have paste options where you can select to paste the formula or data. If you hover over the options, it'll tell you what it'll paste.
Really helpful and too the point thanks. I needed this due to my fantasy excel page that I am working on the site I am using seperated the names just as you said and it messed with the book I was working again thanks
+Allen Anderson Glad you found it useful :)
Hi, I am trying to past a list of names from word and make them go in separate vertical columns, cant find how to do that, can you help me?
If you're copying from word and they're being listed in one column, you can copy that column again and then paste as transpose.
When pasting, if you right-click, the 4th paste option should say "Transpose" - this will take your rows and paste them as different columns. Hope that helps!
yes, it works, but only with 5 names at the time, thanks anyway,
That's very weird. I just tested with 25 items, works without any issues. What version of Office are you running? And what OS?
excell 15.13.3 copyright 2015, os el capitan 10.11.6
I don't have a Mac to test on. So I'm wondering if that's a mac only issue. I tried a couple other times, haven't been able to replicate it on my windows machine.
Thank u, u save my time, i have do 6345 entries, i typed it till 3k ..And I watch ur vdo, and u save time
Glad this was helpful :)
Very long-winded explanation, should take 20 seconds. Too much talking :(
Thanks for the feedback. I'll admit my older videos weren't as organized but I try to focus on the 'why' as well as the 'how' so my videos tend to be more wordy. I also use a lot of analogies because the videos are meant to be for beginners and all those words add up.
Thanks for watching!
any chance u can show how to add : between firstname and lastname pls?
Something like this should work:
=A1&":"&B1
You can add your own text inside the quotes. I put a space in the video but you can replace it with a colon.
@@naztronaut thanks
can it works on numerical values??
Yes but if you use this method, it'll turn the numbers into text values and you won't be able to do calculations. If that's not a concern, then it will work exactly the same.
since you seem to be well-versed in programming and I am just starting, what language would you recommend I start with learning first?
Thank you!
I think the kind of language you want to learn depends on what you want to do. For beginners, I usually recommend starting off with JavaScript because it's really easy to get started. You don't need any kind of IDE and can just run it on your browser as-is. I also have 56 tutorials on JS here: www.easyprogramming.net/javascript.php
Python is also a popular language to start with, especially if you are into data science. I'd also recommend reading up on algorithms and data structures in general as they will be helpful down the line.
Once you learn one language, it's pretty easy to move onto others. And it's also okay to start a language and move onto something else if you don't like it. Best of luck!
Easier than others, good information provided you
Glad you found it useful!
Thank you so much, this will definitely help me with saving time! Good job!
Glad it was helpful :)
Please tell about dragging under Concatinate function ...... For join large no of words or names ..
Are you referring to autofill? I have a tutorial that covers autofill here: www.easyprogramming.net/exceltutorials/autofill_excel.php
I show you how to drag any function all the way by dragging or double clicking. Starts around the 9:00 minute mark.
omgg... It doesn't work for me it keeps giving me an error..... =D327&'' ''&E327 this is my formula. Can you please help? :)
When I copy and paste your formula, your quotes are 2 single quotes so it fails, Can you switch it to double quotes instead? You can copy and paste this:
=D327&" "&E327
@@naztronaut what do u mean by 2 Single quotes ?
@@Akhan1999 I meant the apostrophes like this: '
I'm too used to programming speak. Apostrophes are called single quotes and regular quotation marks are double quotes.
How to use comma between the word?
Just add the following:
&", "&
It's similar to adding a space that starts at 3:45 in the video.
talk too much
Thanks so much!!
Thanks
Good
Seriously It took 3 seconds to explain, and you take 8 min.
Thanks for the feedback. I'll admit my older videos weren't as organized but I try to focus on the 'why' as well as the 'how' so my videos tend to be more wordy. I also use a lot of analogies because the videos are meant to be for beginners and all those words add up.
Thanks for listening!
Thanks for your support
Didnt work 🥴
Where did you get stuck?
make the definition alon
What will be for number formatting cell?
Can you be a little more specific? Do you mean if it will concatenate numbers?
But if we want to merge in coulum? Then what will we do
Are you going to make a new cell or are you trying to merge A1 into B1? If the latter, then you can't do it without overriding one of the values. If you're making a new Cell and you're in the same column (let's say A1 and A2) then just do =A1&A2 into your new cell. Then you can copy that into whichever cell you'd like.
Hope this helps!
Sir 1 thing more i want to ask i hope u'll help me...i have emails and names in 1 column example:A1=JOHN
A2=EMAIL, A3=ALI AND A4= EMAIL and countinous...means in same coulum firstly name and then their e-mail sir how i copy their names and paste in front of email...?they are thousand male its hard to copy one by one
@@attiqurrehman6134 That's a tough one. There could be a few ways to do it and one that comes to the top of my head is doing a formula like this: =A1&A2
Then you autofill all the way down. This will make all Even numbered rows wrong. You can then select all Even Number Rows and remove them. You can also set up a filter by creating a third column with this formula: =ISEVEN(ROW(A1))
That means if the row is an "odd" number like A1, it'll be "FALSE" otherwise it'll be 'TRUE' - you can then select all TRUE values and filter them out.
Let me know if this helps in any way. It's a couple more steps but I think this would be the easiest path for you.
@@naztronaut hye, thanks for information...sir, if i send u a screenshot then u can understand better and there'll be more beneficial for me if u make a video on it....sir if u done this than i'll be very thankful for your help & sir u can save my time...its request
@@attiqurrehman6134 I wish I had time to make these videos. Sadly I don't think I'll be making any more Excel videos anytime soon and no videos until early 2020 at this point.
Video starts at 2:15
How can I copy the result from C1 to another table?
Thanks a lot! :)
ruclips.net/video/km2CpKkP4xU/видео.html
Already found the answer, thanks tho! :)
@@MrKristoSoitu Awesome! Yup, paste as values is the best way course of action.
If i select 1 cell of column C I get formula instead of actual value "John Smith". How can I get only "John Smith" ???
you talk too much....
Thanks for the feedback. I'll admit my older videos weren't as organized but I try to focus on the 'why' as well as the 'how' so my videos tend to be more wordy. I also use a lot of analogies because the videos are meant to be for beginners.
Thanks for listening!
That udemy add tho....😍
What's the udemy add?
So i did everything but it just has the formula it didn’t merge my info together? Can you help me ?
What does your formula look like and which cells is the data in?
I have it as =A2&”-“&B2”-“&C2 & it doesn’t merge the info together it’ll just stay in the format or it’ll give me an error message. 😖
Okay now it’s not letting me grab C2.
@@amigarza8090 You're missing an ampersand after the B2. It should be this:
=A2&"-"&B2&"-"&C2
OMG THANK YOU! 🤣 I’ve been trying to figure it out since 9 this morning! Thank you so much !
2 minutes in i gave up
I'll admit my older videos weren't as organized as I tried to focus on the 'why' as well as the 'how' so my videos tend to be more wordy. I also use a lot of analogies because the videos are meant to be for beginners and all those words add up.
Thanks for listening!
do you make macros?
Hey there, You can make macros, but unfortunately I haven't had any videos on that :(
My friend, you just saved me HOURS of work. Thank you!!
Glad this old video is still helping people!
That was so helpful! Thank you!