How to copy values from two cells and paste in another cell, while preserving the format of both cells?

Amir Published at Dev

Amir

I have two cells in my excel sheet, one cell contains string such as below:

Gross amount:

while the other cell has currency in euros, for instance:

223.463.687€

Now I want to copy both of these values, i.e. "Gross amount:" and "223.463.687€" and past it into a third cell. The formula that I am using is this:

=(A42&""&B42)

and I get the following result:

Gross Amount: 223463687,150838

But I should have:

Gross Amount: 223.463.687€

NOTE:

The format of currency is in German format, which means that "." (decimal point) and "," (coma) play the opposite roles. In German format, "," is the decimal point where as in English it is ".".

LocEngineer

Try this:

=A1 & " " & TEXT(B1;"###.###€")

Edit: Interesting effect! 0 does not get interpreted as "0". Therefore little amendment, German notation (English would be If with , delimiter of course):

=A1 & " " & WENN(TEXT(B1;"###.###")="";"0 €";TEXT(B1;"###.###€"))

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at2021-02-21

Comments

0 comments

From Dev

Copy/Paste only cells with values

From Dev

In Excel, how can you copy/paste multiple cells into the editing of another cell?

From Dev

How to 'copy' and 'paste special' 'values only' if the cells are highlight orange (or any colour) by combining these two scripts

From Dev

Excel VBA macro - find the cell location from which cells in two columns match the row and column in another workbook then paste a value

From Dev

Related Related

Article