Is there a formula

I have posted a file that shows the details but this is what is being asked:

Cell A2 is using a list. The amount in B2 is free keyed. D2 has been concatenated but what the user wants it to look like is the one in G2 with the currency, space and amount with the comma and dot

Currency       Amount                     Ccy/Amnt                          Needs to look like
USD               1,000.00             USD 1000                  USD 1,000.00

is this possible
JagwarmanAsked:
Who is Participating?
 
Phillip BurtonConnect With a Mentor Director, Practice Manager and Computing ConsultantCommented:
=A2& " " & TEXT(B2,"#,##0.00")
0
 
JagwarmanAuthor Commented:
Brilliant thanks Phillip
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.