Office 2010 Class #21: Excel Formulas & Functions: Formula Inputs Numbers or Cell References?

[uomo84]

Without dragging the formula down, how can you make the result automatically form in row c? For ex if you have thousands of names in Row A and B how can you make all automatically combine A and B show the results in C --This did not ork but as a helper A:A&" "b:b ?

[ExcelIsFun]

@uomo84 , try: highlight whole column (click in C1 then Ctrl + Shift + Down Arrow), then enter formula in Active Cell C1: A1&" "$B1, then Ctrl + Enter.

[hzmtk22]

Sir, you've made me speechless! You are simply the best!

[ExcelIsFun]

I am glad that you like the videos!

[dustykimmer]

How do I do the double quotes for this formula above for text spacing?

[ExcelIsFun]

I am not sure I understand your question. But if you are asking how to add a space to a text formula, you have to put the space in double quotes:

" "

If that's not it, restate question.

[TheClanWarsChanal]

this video is EXCELlent

[ExcelIsFun]

Thanks!!

[Nicola72av]

Hi teacher!

Your lessons are very beautiful and interesting!

Thanks a lot for your great job!

I send you a dear greeting from Italy... :)

have a nice day! :)

[ExcelIsFun]

You are welcome a lot!

[Desiboy2066]

thanx man superb :)

[ExcelIsFun]

I am glad that this helps!!!