| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text to columns 2007
Greetings all!
I am working with an 07 Excel spreadsheet and would like to use the Text to Columns feature. It is working just fine. However, I'd like to take it one step further and have the destination cell be on a separate spreadsheet. When I change the destination, I get an error message that says Destination reference is not valid. Here is what I have listed for the destination: =Sheet2!$A$2 Thanks for your help! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text to Columns not working correctly with dates in Excel 2007 | Excel Discussion (Misc queries) | |||
| help with sorting text in columns to match other columns | Excel Discussion (Misc queries) | |||
| Convert Text to Columns with Excel 2007 beta does not work well | Excel Worksheet Functions | |||
| Excel 2007 Beta 2 Error -- Text-to-Columns Wizard Data preview wha | Excel Discussion (Misc queries) | |||
| Linking text columns with text and data columns | Excel Worksheet Functions | |||
Threaded Mode
