| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Search and find all "$" in a string
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, |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Search and find all "$" in a string
Use Replace
MyString = Replace(MyString,"$","") "DontKnow" wrote: 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, |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Search and find all "$" in a string
Where did you get that text from? If it was from the Address property of a
Range, you could have that property give it to you in the form you want by making use of its optional arguments. For example, execute this line in the Immediate Window... MsgBox Range("B2:H3").Address & vbCrLf & _ Range("B2:H3").Address(False, False) Notice the $ signs in the first line and, for the same range, the lack of them in the second line. -- Rick (MVP - Excel) "DontKnow" wrote in message ... 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, |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Search and find all "$" in a string
Thanks Guys
Thats excellent!! Cheers "Rick Rothstein" wrote: Where did you get that text from? If it was from the Address property of a Range, you could have that property give it to you in the form you want by making use of its optional arguments. For example, execute this line in the Immediate Window... MsgBox Range("B2:H3").Address & vbCrLf & _ Range("B2:H3").Address(False, False) Notice the $ signs in the first line and, for the same range, the lack of them in the second line. -- Rick (MVP - Excel) "DontKnow" wrote in message ... 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, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| need a formula to find "*" in s string and multiply by preceding andfollowing values | Excel Discussion (Misc queries) | |||
| How to search for "@" in text string? | Excel Worksheet Functions | |||
| HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
| using "find" or "search" to find commas | Excel Discussion (Misc queries) | |||
| Binocular search tool, Excel, loses column designation at "Find" | Excel Discussion (Misc queries) | |||
Hybrid Mode
