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

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.
Leonardo MAsked:
Who is Participating?
 
Saqib Husain, SyedEngineerCommented:
Or simply

="The rate is "&A2
0
 
YamaafgCommented:
Hi,

This formula should do it:

="The rate is"&" " &TEXT(A2,"0.00")
0
 
Leonardo MAuthor Commented:
Thanks!!!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.