Solved

How to add/join a text with a number in excel

Posted on 2016-10-28
3
37 Views
Last Modified: 2016-10-28
Dear Experts,

Can anyone please tell me an excel formula that I can use to to get the following result in column B:

A                                         B
25.50                                  The rate is 25.5
30.00                                  The rate is 30.00

Thank you.
0
Comment
Question by:Leonardo M
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 5

Assisted Solution

by:Yamaafg
Yamaafg earned 250 total points
ID: 41863704
Hi,

This formula should do it:

="The rate is"&" " &TEXT(A2,"0.00")
0
 
LVL 43

Accepted Solution

by:
Saqib Husain, Syed earned 250 total points
ID: 41863706
Or simply

="The rate is "&A2
0
 

Author Closing Comment

by:Leonardo M
ID: 41863715
Thanks!!!
0

Featured Post

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Access Database 5 48
using vb script 5 52
Formula to pull out part of text in cell 3 25
Some sheets won't re-calculate unless you stop and step through the code 3 19
Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question