<div>
<div class="content wysiwyg-content">
I have posted a file that shows the details but this is what is being asked:<br />
<br />
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<br />
<br />
Currency &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Amount &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; Ccy/Amnt &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; Needs to look like<br />
USD &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1,000.00 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;USD 1000 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;USD 1,000.00<br />
<br />
is this possible
</div>
</div>


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

Is there a formula

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.