| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text Being Seen as Partial Cell Address
(I'm using MS Excel 2003 (11.8120.8122) SP2)
Please change the priority of Text Only to override the process by which Excel flags cell addresses. True, "HP2" is a potential cell address, but "CCC2-0307, HP2-0106" is not, especially if the cell is set for text only. It is exasperating to have to change an entire database just because Excel insists on reading text with potential cell addresses as actual partial formulae. Again, designating a cell/column/row/worksheet as Text should override any automatic search by Excel for cell addresses. The other option is to be able to disable this searching process in the Options menu. -- Mike S. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Text Being Seen as Partial Cell Address
You MIGHT change your A1 references to R1C1 in Excel (tools/options/general)
before opening the file -- then CCC2-0307 will NOT be thought of as a reference. "Mike S." wrote: (I'm using MS Excel 2003 (11.8120.8122) SP2) Please change the priority of Text Only to override the process by which Excel flags cell addresses. True, "HP2" is a potential cell address, but "CCC2-0307, HP2-0106" is not, especially if the cell is set for text only. It is exasperating to have to change an entire database just because Excel insists on reading text with potential cell addresses as actual partial formulae. Again, designating a cell/column/row/worksheet as Text should override any automatic search by Excel for cell addresses. The other option is to be able to disable this searching process in the Options menu. -- Mike S. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Text Being Seen as Partial Cell Address
It's not the CCC2 that's being seen as a reference, it's HP2. Still, I'll
try your suggestion. -- Mike S. "Bob Umlas, Excel MVP" wrote: You MIGHT change your A1 references to R1C1 in Excel (tools/options/general) before opening the file -- then CCC2-0307 will NOT be thought of as a reference. "Mike S." wrote: (I'm using MS Excel 2003 (11.8120.8122) SP2) Please change the priority of Text Only to override the process by which Excel flags cell addresses. True, "HP2" is a potential cell address, but "CCC2-0307, HP2-0106" is not, especially if the cell is set for text only. It is exasperating to have to change an entire database just because Excel insists on reading text with potential cell addresses as actual partial formulae. Again, designating a cell/column/row/worksheet as Text should override any automatic search by Excel for cell addresses. The other option is to be able to disable this searching process in the Options menu. -- Mike S. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Text Being Seen as Partial Cell Address
I just tried it, and it worked for 2 values "HP1" and "HP2". (I converted
the HP's to HMP.) But, "HP3" is still being seen as a cell reference. What gives? (And, yes, I've checked the help files, but they do not address this issue. Also, all the listed help file entries show no "HP"s anywhere.) -- Mike S. "Bob Umlas, Excel MVP" wrote: You MIGHT change your A1 references to R1C1 in Excel (tools/options/general) before opening the file -- then CCC2-0307 will NOT be thought of as a reference. "Mike S." wrote: (I'm using MS Excel 2003 (11.8120.8122) SP2) Please change the priority of Text Only to override the process by which Excel flags cell addresses. True, "HP2" is a potential cell address, but "CCC2-0307, HP2-0106" is not, especially if the cell is set for text only. It is exasperating to have to change an entire database just because Excel insists on reading text with potential cell addresses as actual partial formulae. Again, designating a cell/column/row/worksheet as Text should override any automatic search by Excel for cell addresses. The other option is to be able to disable this searching process in the Options menu. -- Mike S. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Text Being Seen as Partial Cell Address
In light of my subsequent responses, I've since changed my database code from
"HP" to "HMP". This works, but the "HP3" issue still bothers me. Do you have any idea why Excel see "HP3" as a partial formula? Or why Excel's suggested help files do NOT display evidence of the "HP3"? PS: Thanks for your input -- Mike S. "Bob Umlas, Excel MVP" wrote: You MIGHT change your A1 references to R1C1 in Excel (tools/options/general) before opening the file -- then CCC2-0307 will NOT be thought of as a reference. "Mike S." wrote: (I'm using MS Excel 2003 (11.8120.8122) SP2) Please change the priority of Text Only to override the process by which Excel flags cell addresses. True, "HP2" is a potential cell address, but "CCC2-0307, HP2-0106" is not, especially if the cell is set for text only. It is exasperating to have to change an entire database just because Excel insists on reading text with potential cell addresses as actual partial formulae. Again, designating a cell/column/row/worksheet as Text should override any automatic search by Excel for cell addresses. The other option is to be able to disable this searching process in the Options menu. -- Mike S. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find partial text contained in another cell | Excel Discussion (Misc queries) | |||
| Partial Address match in an array | Excel Discussion (Misc queries) | |||
| Vlookup partial text from a single cell | Excel Worksheet Functions | |||
| Make new column using partial text in another cell | Excel Worksheet Functions | |||
| Finding Partial Text in a Cell | Excel Worksheet Functions | |||
Linear Mode
