| 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, |
| 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) | |||
Threaded Mode
