#1
|
|||
|
|||
Use wildcards to replace some characters
Hi there I am trying to replace some characters in a Excel and basically what I want is to remove the first two minus signs from a list of numbers, like I show below
Thank you |
#2
|
||||
|
||||
Hello
perhaps =SUBSTITUTE(SUBSTITUTE(A1;"-";"";1);"-";"";1) ( replace semi-colons with commas if needed)
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
Thank you very much it worked perfectly
Regards |
Tags |
wildcards |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
best way to use search/replace wildcards in this scenario? | dylansmith | PowerPoint | 3 | 03-04-2023 08:55 PM |
Search and Replace special characters between word using wildcards | mauuuuu5 | Word | 1 | 08-23-2015 09:20 PM |
Find & Replace: Wildcards (except this pattern) | tinfanide | Word | 6 | 01-26-2014 06:39 AM |
Word 2010: Wildcards Replace | tinfanide | Word | 2 | 09-10-2011 10:40 AM |
Any wildcards search and replace in Powerpoint 2010? | tinfanide | PowerPoint | 0 | 09-10-2011 02:17 AM |