?
Solved

Is there a formula

Posted on 2015-02-19
2
Medium Priority
?
48 Views
Last Modified: 2015-02-19
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
Comment
Question by:Jagwarman
[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
2 Comments
 
LVL 24

Accepted Solution

by:
Phillip Burton earned 2000 total points
ID: 40618422
=A2& " " & TEXT(B2,"#,##0.00")
0
 

Author Comment

by:Jagwarman
ID: 40618456
Brilliant thanks Phillip
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

752 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