Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

Excel 2003 question


  • Please log in to reply

#1
diggeryo

diggeryo

    Member

  • Member
  • PipPipPip
  • 343 posts
Is there anyway to use the Edit/Replace function to replace an asterickt? Anytime I try to, it replaces everything.
  • 0

Advertisements


#2
dsenette

dsenette

    Je suis Napoléon!

  • Administrator
  • 26,019 posts
  • MVP
try putting the asterisk in quotes as an asterisk by itself is a wild card
  • 0

#3
diggeryo

diggeryo

    Member

  • Topic Starter
  • Member
  • PipPipPip
  • 343 posts
thanks for the reply, but it didn't work. any other suggestions?
  • 0

#4
Octagonal

Octagonal

    Member 2k

  • Member
  • PipPipPipPipPip
  • 2,528 posts
Hi diggeryo,

If you want to only replace an asterisk then you must put a ~ in front of the asterisk.

For example if your list is:

b*t
do*
*cho
*volv*

When the tilde is placed before the asterisk the list changes to

bet
doe
echo
evolve

If this is what you are trying to achieve then your syntax in the Find/Replace box would be

Find What : ~*
Replace With : e

HTH
  • 0

#5
diggeryo

diggeryo

    Member

  • Topic Starter
  • Member
  • PipPipPip
  • 343 posts
Sweet, it worked. Thanks, Octagonal!
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP