| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Taking formula to text
I have a formula which I need to be able to copy/paste to a "Save As" file
name. Column A Column B R1 Prod LP10 R2 DivOp1 PUA R3 14 R4 M R5 1 Formula is =Prod&"-"&DivOpt1&"-"&B3&B4&B5 The formula returns "LP10-PUA-14M1". This is supposed to be the name for a file. Yet I cannot copy this result and paste the name in the "Save As" file name. I've tried Text, T, and a few others. Any alternatives to solve this problem? End result as text is supposed to be "LP10-PUA-14M1" |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Autofilter COUNTA formula not taking into account hidden cells | Excel Discussion (Misc queries) | |||
| need help w/ formula for taking lunch & overtime out of a 9 hour | Excel Discussion (Misc queries) | |||
| taking percentages | Excel Discussion (Misc queries) | |||
| taking two worksheets together | Excel Worksheet Functions | |||
| how do I stop "copy" taking a picture instead of copying text | Excel Discussion (Misc queries) | |||
Threaded Mode
