|
|
#1
12-12-2015, 10:43 AM
|
|||
|
|||
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
12-12-2015, 12:33 PM
|
||||
|
||||
|
Hello
perhaps =SUBSTITUTE(SUBSTITUTE(A1;"-";"";1);"-";"";1) ( replace semi-colons with commas if needed)
__________________
Using O365 v2503 - 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
|
|
| Tags |
| wildcards |
|
|
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 |
Windows 7 64bit 
Office 2010 64bit
Linear Mode
