| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 80782 | 2007-07-05 03:25:00 | CONCATENATE in excel | flipflop (12459) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 565906 | 2007-07-05 03:25:00 | I have a spreadsheet where I have used the IF and CONCATENATE formulas to get the value I want. For example if I have CELLS A1 to D1 which contain data, I use the above formulas to give me a value in E1 of say "P[123456] 1234 56 7890 12 01A" My question is I now need to copy that value to another program (maybe into notepad). How can I convert the value I see into something that I can cut and paste to notepad? When I select the CELL, only the formula is available, not the value. Hope that makes sense, and someone can help. Many thanks :illogical |
flipflop (12459) | ||
| 565907 | 2007-07-05 03:49:00 | Hi Select the cell in question, select menu option 'Edit' > 'Copy', then select another cell, select menu option 'Edit' > 'Paste Special' > 'Values' > 'Ok'. This will give you a value you can copy and paste elsewhere. Andrew |
andrew93 (249) | ||
| 565908 | 2007-07-05 03:57:00 | thanks a million :) | flipflop (12459) | ||
| 1 | |||||