Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-12-2015, 10:43 AM
mauuuuu5 mauuuuu5 is offline Use wildcards to replace some characters Windows 7 64bit Use wildcards to replace some characters Office 2010 64bit
Novice
Use wildcards to replace some characters
 
Join Date: Aug 2015
Posts: 3
mauuuuu5 is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 12-12-2015, 12:33 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Use wildcards to replace some characters Windows 7 64bit Use wildcards to replace some characters Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,770
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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
Reply With Quote
  #3  
Old 12-12-2015, 07:27 PM
mauuuuu5 mauuuuu5 is offline Use wildcards to replace some characters Windows 7 64bit Use wildcards to replace some characters Office 2010 64bit
Novice
Use wildcards to replace some characters
 
Join Date: Aug 2015
Posts: 3
mauuuuu5 is on a distinguished road
Default

Thank you very much it worked perfectly

Regards
Reply With Quote
Reply

Tags
wildcards

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Use wildcards to replace some characters best way to use search/replace wildcards in this scenario? dylansmith PowerPoint 3 03-04-2023 08:55 PM
Use wildcards to replace some characters 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
Use wildcards to replace some characters 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

Other Forums: Access Forums

All times are GMT -7. The time now is 07:30 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft