• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 50
  • Last Modified:

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
0
Jagwarman
Asked:
Jagwarman
1 Solution
 
Phillip BurtonCommented:
=A2& " " & TEXT(B2,"#,##0.00")
0
 
JagwarmanAuthor Commented:
Brilliant thanks Phillip
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now