Thank you. The clarity and examples were on point!!

Hi Hector, Thank you for explaining the new formulas. I am doing an online course and have just come across CONCAT , and wondered what it was. I hadn't heard on concatenate either. But I feel I have a better understanding now. And its much quicker watching your video than trying to ask online tutors that take a good while to get back to you and then to not always understand when you do get through to them, is real frustrating to say the least. So once again, Thank you.

Thank you so much. This has greatly helped. I know I'll be back, but I didn't know about TEXTJOIN! Thanks again!

thanks a lot i was exactly searching for textjoin formula,thanks again

@HectorGarciaCPA

6 жыл бұрын

Great!

Thanks for the explanation of the new Excel TEXTJOIN function. Very helpful.

@HectorGarciaCPA

4 жыл бұрын

You welcome

Awesome video, pls make more videos on excel, make full series on excel from beginner to Advanced, your teaching style is simply awesome. Thanks

Thank you, helped me remember and apply TEXTJOIN()

@HectorGarciaCPA

5 жыл бұрын

Awesome

Thanks for giving this example. It helps me in interview

@HectorGarciaCPA

4 жыл бұрын

Great.

This is a game changer. Thanks. How am I just hearing about TextJoin and Concat now? Thanks so much

@HectorGarciaCPA

3 жыл бұрын

We are always learning new things I guess

This video was very helpful. Thank you! How are you getting your formula to show in the cell beside each one?

@HectorGarciaCPA

2 жыл бұрын

=FORMULATEXT()

Thank you for your video. =TEXTJOIN allows to use ignore empty cells & delimiter. What's the difference between =CONCAT and =CONCATENATE

Loving how this handles blank cells

@HectorGarciaCPA

4 жыл бұрын

Amazing

I would love to learn more about formulas and formatting.

@HectorGarciaCPA

7 жыл бұрын

+Angela Snyder any specifics? "Formulas and Formatting" is very broad

@angelagarrett5699

7 жыл бұрын

I have a $ in one of my formulas Example: =AK20*$C20. What does the $ do? I thought it had to do with formatting.

Hi, do you think it's easier to join the 2 cells by using the cell reference and & sign instead of CONCAT() or TEXTJOIN()? what should I use to join? i.e. =A2&B2&C2&D2

@HectorGarciaCPA

7 жыл бұрын

+dave cheung you are right if its only a few cells... but concat can help if its a range. And Textjoin ads a delimiter which is huge

@davecheung6957

7 жыл бұрын

you are the greatest.

I am using excel 2016 and there is no CONCAT function? MS has deteled this function????

@HectorGarciaCPA

5 жыл бұрын

Tran Duy Hung yes there is.. I use it all the time.

@gppg6290

4 жыл бұрын

MS says it only works with 365 subscriptions - same goes for IFS support.office.com/en-us/article/ifs-function-36329a26-37b2-467c-972b-4a39bd951d45 and TEXTJOIN - what a bummer for those of us that bought Excel 2016

Excel 2019 version but uploaded in 2016??? MAKES SENSE

@HectorGarciaCPA

2 жыл бұрын

The features are identical