Excel 2007: Combine contents of multiple cells into 1 cell

[7orqu3]

i have a situation where there is a column of dates and along side them they are values for % for amounts on each day. now i can make it so i get back the MAX value of the % amounts but how do i get it so i get  MAX % in the column and the corresponding date ????

the MAX function is easy just pick a data raneg but linking the MAX value to the cell alongside it has me stumped

[Pristina011]

Thank you so much, Ive been trying to figure this out for ages.... This formula is great, it definatley needs more people knowing about it. Thank again xxx

[viprealtorgirl]

thank you so much that was amazing useful

[machmach31]

THANK YOU SO MUCH!! I REALLY APPRECIATE THIS VIDEO.:)

[SHSephiroth]

This makes life so much easier, Awesome video!!!

[locbuspro]

you have jsut saved me about 20 hours work, thank you!

[shuaigeUSA]

There are from Microsoft

[kaushalapatel]

it works..thanks for uploading such a good help.

[kaushalapatel]

it works..thanks for uploading such a good help.

[maddog956]

This is AWESOME and exactly what I needed. Thank you for providing a simple way of doing this for something I need to do on a frequent basis.

Thanks!

[PrestoBaggins]

This was very helpful thanks

[AZWRAITH73]

not working

[AZWRAITH73]

w3w

[timmunozlasvegas]

WHO EVER DOES THESE VIDEOS', I LOVE YOU. SERIOUSLY, I LOVE YOU.

[stluke324]

@timmunozlasvegas ....i approve this message..lol

[ssstto]

dis useless, how about 200 cells

[Questix]

For 200 cells, you would simply need to drag cell C down and it would copy the formula. It's not useless, ssstto, it's amazing. I'm very grateful to have found this! Thanks for posting, Demo Trainer!

[waseemakhlaq123]

Sir this video is not clear can u send me formula of combile the cells thanks

[jslizzzle]

click the HQ button under the video

[eradiodesign]

TY...Very easy

[nizuguy]

Great help on combining values of two cell into one cell in MS Excel.

[marccram73]

How can you do the opposite? I copied data from word but the entire data is in 1 cell. Is there a way to place them in multiple cells without cutting and pasting the entire data seperately?

[nizuguy]

You may use the "Text to Coloumn" option in the Data menu.