| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula text to columns
I have a few formulas resulting from a vlookup:
=IF(ISERROR(VLOOKUP(K17&" "&M17&" "&O17&" "&Q17,J29:J73,1,FALSE)),"",VLOOKUP(K17&" "&M17&" "&O17&" "&Q17,J29:J73,1,FALSE)) This returns the correct answer, but when I try to separate the result into columns, all I can see is the formula in the text to columns work box. Since I want to leave this formula in place to use for future changes, I don't want to use a copy/ paste values and lose the formula. Is there a way to work with the values and still keep the formula? TIA |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| hi - is there a formula that matches text in different columns? | Excel Worksheet Functions | |||
| Text to columns on a formula | Excel Discussion (Misc queries) | |||
| Splitting text, like "Text to columns", but as a formula | Excel Discussion (Misc queries) | |||
| Text to columns using a formula | Excel Discussion (Misc queries) | |||
| text to columns: is there a formula? | Excel Worksheet Functions | |||
Threaded Mode
