| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Concatenate Data inn different columns
Hi,
I would like to concatenate the data in 2 different columns as shown below into 1:- CURRENCY_CODE TOTAL_OUTSTANDING_VALUE MYR 6,864.00 MYR 6,864.00 MYR 82.60 MYR 76.00 MYR 276.60 MYR 106.40 USD 758.31 USD 1,411.00 USD 1,388.73 USD 2,797.11 JPY 1,504.83 JPY 690.40 JPY 139,941.00 Actually, I have found the ways to concatenate those data by using the function Concatenate and using the &. But after those data have been concatenated, the number in 2nd column became text. So, is there any other way that we still can remain the value of number after caoncatenated the data? Any advise... Thanking in advanced. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sorting 2 colums of numbers and incremening them down | Excel Discussion (Misc queries) | |||
| Macro question | Excel Worksheet Functions | |||
| Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
| Sort pages? | Excel Discussion (Misc queries) | |||
| How do i copy columns of data in notepad into microsoft excel? | Excel Discussion (Misc queries) | |||
Threaded Mode
