Concatenate is a cool feature. I have to admit, when I first saw this feature I felt like wow!, this is a lot to remember, but once I got it down I'm loving it, this is great.
I know now, how to add a whole string of text together with this function, that cuts the typing time in half. This is awesome, to be able to combine contents from different cells together into a single cell. I also learned how to Concat first and last names without having to type the whole thing, and how to add emails in with the text. This feature is so cool. You can even use the '&' symbol as a shortcut to Concat a string of items together into the same cell.
I have learned how to add space, comma, and period, into the data by putting it in quotations. Quotation in an Excel function, let the computer know it is working with text. I am in awe about these new functions, not just Concat but a few others. Excel is pretty cool, I wish I knew all these functions years ago. I love all the new features I am learning about Microsoft Excel.
The Concatenate/Concat function is definitely useful in joining strings of text and symbols :-)
ReplyDeleteVery glad you learned about this function and others in Chapter 5 Microsoft Excel ^_^
I agree. I have been having more trouble with Excel than in Word but I know in the end I will be glad I learned it in this class than struggling when I am going to have my first job.
ReplyDeleteConcatenation is super helpful when you're working with textual data that's poorly organized/regimented. It can definitely spare you a lot of headaches when working with real-word data.
ReplyDeleteI was stuck on concatenation for a bit on the fun with excel work book. But it is a good feature once mastered.
ReplyDeleteAgreed, the concat function is super helpful!
ReplyDeleteThe concat function is really good and very simple to use once you learn how to use it!
ReplyDeleteIt's a cool function, but I struggled with it. I did, however, got some valuable help from the professor on how to properly use that function.
ReplyDeleteI must say the concat function is my favorite to use.
ReplyDeleteThe concat function is so useful. Once I learned how to use all those tedious functions properly, I felt very big brained.
ReplyDeleteI never knew something like the concat function existed. super neat!
ReplyDeleteConcat was a fun one to learn out of all the functions.
ReplyDeleteI'm having fun with functions I've been using it at work and now spreadsheets aren't that annoying anymore.
ReplyDelete