• Formulas
  • Excel Tips & Tricks
  • Excel Charting
  • Tutorials
  • VBA
  • Book Store
  • More  
    • Blog
    • Download Area
    • Excel Video Tutorials
Home » How To Concatenate Numbers And Percentages – Formula Friday

How To Concatenate Numbers And Percentages – Formula Friday

March 16, 2018 by Barbara

Hi Excellers. Today it is time for some more formula fun. Here is one way to display percentages and numbers together in one column that are currently stored in separate columns on a worksheet, it’s a neat little trick I used recently when I had to display both a numeric value as well as it’s corresponding percentage value in the same text box on a diagram in Excel. We use the concatenate formula or function to do this.

All I needed to do was join or ‘concatenate’ the two values into one column then reference the text box to that column cell. The result was a nice, neat annotated diagram.

Do you want to learn the basics about Concatenate?.

The syntax of this formula is

=CONCATENATE(TEXT1,TEXT2…)

Up to 255 text entries can be added to the function and each one of them should be separated by a comma. One point to note, CONCATENATE does NOT add in extra spaces between text, in order to do this, you need to accommodate these extra spaces within the formula.

Or you can check out my Blog Post right HERE!

If you want to jump right in and look at joining together a number and a percentage then the syntax of the formula looks something like this:-

=CONCATENATE(A2,” “,TEXT(B2,”0%”))

See it in action in my example below

Pin it! Share on Facebook

Give this one a go- let me know how you get on. How easy was that?. Don’t be put off by this terminology, the concatenation of cells is one handy little Excel feature that is fabulous. Basically, it means combining the values of two cells. The great thing about Excel is that it has functions that work with arithmetic functions but it also ones that work well with text as we have seen.

 

Want To Become Even More Awesome In Excel?….Then Check Out My Recommended Resources

Update Your Excel Skills

 

 

 

Filed Under: Blog, Excel Tips& Tricks, Formula Friday, Formulas Tagged With: Excel, Excel Tips, Formula

Comments

  1. Sisca says

    October 17, 2014 at 2:48 am

    Dear,

    Thank You for your inform and i have been succed used this formula.

    but in my case, for % is 0.11%… if i combine it, percentage just show 0%

    please help me to solve this.

    Thank You

    • Dan says

      August 11, 2015 at 10:38 am

      Change the “0%” to “0.00%” it will keep 2 decimal places…

  2. kushal shah says

    March 22, 2015 at 9:11 am

    how to use minus(-) in concatenate formula

  3. Skawen says

    October 6, 2016 at 12:09 pm

    Thank You this was really helpful !

    • Barbara says

      October 6, 2016 at 7:54 pm

      Glad you found it helpful

      Barbara

  4. Patrick says

    May 2, 2017 at 9:37 pm

    Thanks! This is an awesome workaround that saves me at least 45m a month.

    • Barbara says

      May 2, 2017 at 9:56 pm

      Happy it helps Patrick
      Regards
      Barbara

  5. Dave says

    May 25, 2017 at 1:37 pm

    Why not use & ? It’s much simpler than =concatenate

Tags

Blog Cells Excel Excel Charting Excel Excel Tips Excel Formulas excel tip Excel Tip Category Excel Tips Excel Tips& Tricks excel tutorials Excel Videos Excel Video Tutorials formatting Formula formula friday Formulas macro Macro Mondays Macros Pivot Table Pivot Tables Power BI Power Query Tutorials vb VBA Worksheets

Recommended Excel Resources

Free Excel Dashboard Webinar

Copyright © 2023 · Enterprise Pro Theme on Genesis Framework · WordPress · Log in

SHARE

Additional Info

Want FREE Excel Tips?

Click on my FREE eBook, its my bonus for joining thousands of others who receive my 3 xFREE Excel tips every month in my Excel Newsletter. Join Us!.

Excel Jobs

Excel Charting

Self Expanding Charts
One Click Charts
Create Quick Dynamic Charts
Easy Combination Charts

privacy policy

{ezoic-ad-1}

{ez_footer_ads}