ST Alpha - "Excel Help: I have a sheet with some fields that begin with *. I want to replace the * and leave the after data alone" (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Down to Post

Backboards:

Posts: 162

Excel Help: I have a sheet with some fields that begin with . I want to replace the and leave the after data alone

Posted by Will Hunting (aka JoeMetz) Dec 3 '09, 09:49

but when I do Replace *...it reads the * as a wild card and deletes all the cell contents.

How do I just replace the *

Responses:

this: ~* -- nm - Roger More Dec 3, 09:52
Found it, it's the tilde. -- nm - Will Hunting Dec 3, 09:52
Tags post *tech support* -- nm - Mop (228 lbs) Dec 3, 09:50
Found it. Put a tilde before it -- nm - oblique Dec 3, 09:50 4
- "put a tilde on it" -- nm - Beryllium Dec 3, 09:52
- ah. makes sense. -- nm - TFox Dec 3, 09:52
- Thanks -- nm - Will Hunting Dec 3, 09:52
- yep. -- nm - b. Dec 3, 09:52
Would quotation marks around the asterisk help? (nm) - musubi Dec 3, 09:50
put the * in quotes? "*"? -- nm - TFox Dec 3, 09:50 1
- or, something like =if(left(A1,1)="*",.....) -- nm - TFox Dec 3, 09:52
[deleted]
\* ? -- nm - oblique Dec 3, 09:49

Post a message top