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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text to columns 2007
Chimelle
The destination has to be on the same sheet, even using range names on another sheet which sometimes works. -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.excelusergroup.org web: www.nickhodge.co.uk "Chimelle" wrote in message ... 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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text to columns 2007
Nick,
Thanks for the information! I guess I'll just paste on the same sheet and then copy to new destination if required. "Nick Hodge" wrote: Chimelle The destination has to be on the same sheet, even using range names on another sheet which sometimes works. -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.excelusergroup.org web: www.nickhodge.co.uk "Chimelle" wrote in message ... 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! |
Reply |
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 |