Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Please Help
Dears,
I am trying to do by formula the following but I failed: I have two columns, one has the distance and the other has the height level, and to draw it at the AutoCAD I need to put them in one column with comma in between like First column has the number: 710 Second column has the number: 23.20 I need to create new column to have: 710,23.20 Is it possible without typing it manually? Please help me, I really need it. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Please Help
Put this in C1:
=A1&","&B1 Then copy this down column C. You can fix the values by selecting all the cells in column C and clicking <copy, then right-click in the column and click on Paste Special | Values (check) | OK then <Esc, and after that you don't need the first two columns so you can delete them. Hope this helps. Pete On Feb 18, 6:48*pm, Qaddoumi wrote: Dears, I am trying to do by formula the following but I failed: I have two columns, one has the distance and the other has the height level, and to draw it at the AutoCAD I need to put them in one column with comma in between like First column has the number: 710 Second column has the number: 23.20 I need to create new column to have: 710,23.20 Is it possible without typing it manually? Please help me, I really need it. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Please Help
=A1&","&B1
Regards, Per "Qaddoumi" skrev i meddelelsen ... Dears, I am trying to do by formula the following but I failed: I have two columns, one has the distance and the other has the height level, and to draw it at the AutoCAD I need to put them in one column with comma in between like First column has the number: 710 Second column has the number: 23.20 I need to create new column to have: 710,23.20 Is it possible without typing it manually? Please help me, I really need it. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Please Help
Hi,
A few more example would have been better but this works for your posted example =A1&","&TEXT(B1,"0.00") -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Qaddoumi" wrote: Dears, I am trying to do by formula the following but I failed: I have two columns, one has the distance and the other has the height level, and to draw it at the AutoCAD I need to put them in one column with comma in between like First column has the number: 710 Second column has the number: 23.20 I need to create new column to have: 710,23.20 Is it possible without typing it manually? Please help me, I really need it. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Please Help
Assuming the number in column B needs to be 2 decimal places...
A1 = 710 B1 = 23.20 Enter this formula in C1 and copy down as needed: =A1&TEXT(B1,",0.00") -- Biff Microsoft Excel MVP "Qaddoumi" wrote in message ... Dears, I am trying to do by formula the following but I failed: I have two columns, one has the distance and the other has the height level, and to draw it at the AutoCAD I need to put them in one column with comma in between like First column has the number: 710 Second column has the number: 23.20 I need to create new column to have: 710,23.20 Is it possible without typing it manually? Please help me, I really need it. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|