Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Help!!! Using WildCards for Find and Replace

287 views
Skip to first unread message

vvskpk

unread,
Jan 11, 2010, 4:40:01 PM1/11/10
to
Hi there,

I am using PPT 2007. I am want to use WildCards function for finding and
replacing a string.

My problem is, many ppt decks I will get will have phone numbers as
(xxx)-xxx-xxxx.

I want to replace all those formats to +1 xxx xxx xxxx. (adding +1, removing
brackets for first three digits, and replacing hyphens with spaces)

In Word, we have an option of using Wild Cards while using Find and Replace
option. But in PPT, I am unable to do the same function. I need search where
it is used and to manually replace each.

This is the command I use in Word:
Find What : \(([0-9]{3})\)-([0-9]{3})-([0-9]{4})
Replace With: +1 \1 \2 \3

How can I give this in PPT 2007? Or Any vbcode/Macro so that I can use it?

Thanks in Advance!

sjhy...@gmail.com

unread,
Jun 24, 2015, 2:25:30 PM6/24/15
to
Not sure if this would help, but since you can't do it in powerpoint, export the outline of your presentation to word, do your wildcard changes in word, and then import the outline back into powerpoint. A hammer mechanic's solution, I grant you -- but could do the trick if your presentation's not particularly graphics heavy.
0 new messages