Combining Text and Numbers in Excel.

Posted on October 17, 2007 
Filed Under Excel Tips & Tricks

New to the World of Office, XP and Vista Tips & Tricks?

  Here are a few posts the other readers recommend you check out.

Combining Text and Numbers in an Excel Spreadsheet isn’t always easy.

Follow the next steps and you’ll know how to combine them.

  1. Create one column with the end result in cell B9.

  2. Create a second with the end result in cell C9.

  3. Select Cell B11 and type in the following formula: ="You won " & B9 & " times and you lost " & C9 &" times.".

Only make sure that when you type “="You won "” that you use a space after the “n” otherwise this will show as the end result “You won5 times”.

Excel-Tip-Trick-picture1

This should work in all the Microsoft Excel versions.

Do you want to see more? This is related...

Invite your friends to the World of Office.
Did you ever thought about publishing your own eBook or PDF report?
Invite your friends to the World of Office.
Grab the Easy PDF Toolkit, it was never this easy! If you invite your friends and we will receive at least 3 visitors then you will receive a free copy of this amazing kit and that is including all the cool bonuses. Invite your Friends here!


If you liked this article or you thought it was helpful then you would do us a real big favour by hitting one of the below icons. Thank you!! That’s really cool and we really appreciate your support.





Comments

One Response to “Combining Text and Numbers in Excel.”

  1. Salvatore Hidalgiano on May 17th, 2008 9:23 pm

    Good tip! A more complex example would be nice.Thank you!

Leave a Reply