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

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

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

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~