D
DontKnow
Hi Guys,
I need help to search and find all the "$" in a range so as the outpuit
looks like this
"A10:AG10"
At the moment the unwanted string looks like this
"$A$10:$AG$10"
Is their a way that I can be rid of the $ from my string range.
I have tried instr command and then deleting the found value etc but it is
rather cumbersome.
Can someone help me??
Many thnaks for your input in advance!!
Cheers,
I need help to search and find all the "$" in a range so as the outpuit
looks like this
"A10:AG10"
At the moment the unwanted string looks like this
"$A$10:$AG$10"
Is their a way that I can be rid of the $ from my string range.
I have tried instr command and then deleting the found value etc but it is
rather cumbersome.
Can someone help me??
Many thnaks for your input in advance!!
Cheers,