Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-07-2014, 09:26 PM
lobo115 lobo115 is offline Repeated Character Windows XP Repeated Character Office 2007
Novice
Repeated Character
 
Join Date: Nov 2014
Posts: 3
lobo115 is on a distinguished road
Default Repeated Character


Hello, i have some problems with repeated characters, for example some word said
Code:
wwoorrdd or WWWWoordd or ----wwwooorrdd
, i didn't know how much characters are repeated or wich one they are, i tried with wildcards but i don't know how said that is the same chracter i tried with
Code:
(?){2,}
repleace:\1
but it look for any character so it see
Code:
tp
like a posibility, anyone can help me please thz
Reply With Quote
  #2  
Old 11-07-2014, 09:50 PM
macropod's Avatar
macropod macropod is offline Repeated Character Windows 7 64bit Repeated Character Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

You could use a wildcard Find/Replace, where:
Find = ([A-Za-z]){2,}
Replace = \1
Do note that this will also change valid words, like 'committee' to 'comite'...
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 11-07-2014, 10:10 PM
lobo115 lobo115 is offline Repeated Character Windows XP Repeated Character Office 2007
Novice
Repeated Character
 
Join Date: Nov 2014
Posts: 3
lobo115 is on a distinguished road
Thumbs up

Thz for your answer i think it work for me, i will exclude comonly repeated characters from interval, and search it manually, thank you
Reply With Quote
  #4  
Old 11-08-2014, 12:46 AM
macropod's Avatar
macropod macropod is offline Repeated Character Windows 7 64bit Repeated Character Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Cross-posted at: http://answers.microsoft.com/en-us/o...4-e523b70d38c4
For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Tags
repeated content, wildcards

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
if address is repeated in subsequent records paulys Mail Merge 7 12-08-2014 04:10 PM
Standardise repeated actions TiVivibi PowerPoint 0 10-10-2014 02:06 PM
Repeated Character Repeated updates failure theta30 Office 4 12-08-2013 04:29 PM
Repeated Password Prompts Frank Jr. Outlook 0 07-14-2012 05:13 PM
Repeated Character Repeated Cells in different sheets mhdagtas Excel 2 04-27-2011 12:02 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:42 AM.


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