• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Find and Replace * but not using it as a Wildcard ???

tarynmahon

tarynmahon

Member
I have a list of data that goes something as follows;

AB01*TG

AB02*TG

AB03*TG

AB04*TG


I need to find and replace the * with _ as its in the wrong format for me to do a look up on, the problem is the Find and Replace function is automatically treating the * as a wildcard and therefore replacing the whole AB01*TG with _

The letters and numbers I have just used for simplicity, they could be any combination of letters/numbers therefore I cannot use find *TG for example.
 
Good day tarynmahon

Hui has shown the way......but if you ever need to find and replace a wildcard read on.....


Microsoft Excel uses the tilde (~) as a marker to indicate that the next character is a literal. When you use the Find and Replace dialog box to find or replace a character such as a tilde (~), an asterisk (*), or a question mark (?), you must add a tilde (~) before the character in the Find what box.


Note If you want to find or replace a tilde in a worksheet, you must type a double tilde (~~) in the Find what box.
 
So today was a Success after all

I've learned something new

Thanx BobHC
 
The day gets better a cold beer from the boss for "sorting out the lawns" and to be told by an exalted Ninja that you have past on some thing of use.
 
and another beer from a Ninja


_.._..,_,_

( )

]~,"-.-~~[

.=])' (; ([

| ]:: ' [

'=]): .) ([

|:: ' |

~~----~~
 
And another beer from a Ninja

[pre]
Code: 
'         _.._..,_,_
'        (          )
'         ]~,"-.-~~[
'       .=])' (;  ([
'       | ]:: '    [
'       '=]): .)  ([
'         |:: '    |
'          ~~----~~
[/pre]
 
Nice one Hui,.........but I prefer my drinks on tap :)


https://dl.dropbox.com/u/75495784/Whisky%20on%20tap.xlsx
 
Wow you really must be a Ninja to depict a pint of beer with grammar symbols... either that or you have far too much time on your hands!


Thanks Bobhc, Im sure it will come in very handy
 
@b(ut)ob(ut)hc

Hi!

For the tip: as Hui's said... everyday we learn something new... Thanks!!!

For the file: humbly asking for permission to send your uploaded file to a couple of friends but specially to my girlfriend...

Regards!
 
@tarymahon

Hi!

Hui's learned Excel to do such things... then afterwards he began with formulas and all that stuff.

Regards!
 
Good evening SirJB7


Please be my quest, just make sure that your lady understands =if(A1:XFD="beer","whiskey","malt")
 
@b(ut)ob(ut)hc

Hi!

I'd say that she'd rather use AND instruction instead of IF... and add a comment in next cell like "<----- in that order".

Regards!
 
You must log in or register to reply here.
Back
Top