Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert A1 notation to string without dollar signs
Hello All,
Is there some sort of VBA command (without using Mid, InStr, etc) to convert a cell address (aka string, or even single cell range) from "$F$51" (or R51C6) to just a string "F51". I can parse and cut, etc for $ signs, but I thought there might be a single command that would do this. Thanks, eholz1 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert A1 notation to string without dollar signs
?range(range("a1")).Address(false,false)
-- Kind regards, Niek Otten Microsoft MVP - Excel "eholz1" wrote in message ... | Hello All, | | Is there some sort of VBA command (without using Mid, InStr, etc) | to convert a cell address (aka string, or even single cell range) from | "$F$51" (or R51C6) | to just a string "F51". | | I can parse and cut, etc for $ signs, but I thought there might be a | single command that would do this. | | Thanks, | | eholz1 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert A1 notation to string without dollar signs
How about this...
Replace("$F$51", "$", "") -- HTH... Jim Thomlinson "eholz1" wrote: Hello All, Is there some sort of VBA command (without using Mid, InStr, etc) to convert a cell address (aka string, or even single cell range) from "$F$51" (or R51C6) to just a string "F51". I can parse and cut, etc for $ signs, but I thought there might be a single command that would do this. Thanks, eholz1 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert A1 notation to string without dollar signs
On Apr 8, 3:06 pm, Jim Thomlinson <James_Thomlin...@owfg-Re-Move-
This-.com wrote: How about this... Replace("$F$51", "$", "") -- HTH... Jim Thomlinson "eholz1" wrote: Hello All, Is there some sort of VBA command (without using Mid, InStr, etc) to convert a cell address (aka string, or even single cell range) from "$F$51" (or R51C6) to just a string "F51". I can parse and cut, etc for $ signs, but I thought there might be a single command that would do this. Thanks, eholz1 Wow, Good tips. have info will use, and Thanks again! eholz1~ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In Excel, what do the dollar signs mean in $A$1 | Excel Worksheet Functions | |||
Dollar signs on all tabs | Excel Discussion (Misc queries) | |||
Dollar signs in VBA | Excel Programming | |||
Dollar signs | New Users to Excel | |||
Dollar SIgns in Formulas | Excel Discussion (Misc queries) |