Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-28-2019, 05:32 PM
xxdakee xxdakee is offline Editing words with specific sign Windows 10 Editing words with specific sign Office 2019
Banned
Editing words with specific sign
 
Join Date: Jan 2019
Posts: 1
xxdakee is on a distinguished road
Post Editing words with specific sign

Hi. I'm struggling with I think easy task. How I can edit words preceded with specific sign?
example:
@XXX
@ZZZ
@YYY

to:

XXX
ZZZ


YYY

How I can change every word in front of which there is a @ sign?
Reply With Quote
  #2  
Old 01-28-2019, 07:13 PM
Guessed's Avatar
Guessed Guessed is offline Editing words with specific sign Windows 10 Editing words with specific sign Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,977
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

To find every instance of the @ symbol followed immediately by a letter, with wildcards on
Find: "\@<([a-zA-Z])"
Replace: "\1"

Note that this will also find a@a and 2@a so this is potentially not exactly what you wanted.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #3  
Old 01-28-2019, 08:09 PM
macropod's Avatar
macropod macropod is offline Editing words with specific sign Windows 7 64bit Editing words with specific sign Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
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

Alternatively, and more comprehensively, a wildcard Find/Replace with:
Find = ([ ^s^13^l^t])\@<([a-zA-Z]@>)
Replace = \1\2
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #4  
Old 01-28-2019, 08:47 PM
Guessed's Avatar
Guessed Guessed is offline Editing words with specific sign Windows 10 Editing words with specific sign Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,977
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

Paul
Does that find string work for you when the paragraph begins with @xxx?
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #5  
Old 01-28-2019, 08:50 PM
macropod's Avatar
macropod macropod is offline Editing words with specific sign Windows 7 64bit Editing words with specific sign Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
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

Expanded to incorporate that and a number of others, too, though changing the format of the preceding character in such cases might not be desirable.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to highlight lines containing specific words SixStringSW Word VBA 4 06-03-2018 03:57 PM
Open file which contains specific words in title Nick70 PowerPoint 2 06-08-2016 06:55 AM
Editing words with specific sign Word 2003 Editing: Disappearing Letters and Words dddave Word 2 12-01-2015 05:45 PM
Editing words with specific sign How to allow specific double words in spellcheck Wyndham Word 5 02-06-2014 10:44 AM
Editing words with specific sign Need VBA For Macro On How To Remove Specific Words netchie Word VBA 6 08-28-2012 03:37 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:59 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