Excel Tips - Replace The * Character

I can't figure out what punctuation needs to go before and after the * to
search for only *'s and not to use it as a Wildcard. In the help it says to
use brackets, but that is under the Microsoft Access help, and it didn't work
in Excel.
In the end, I plan to write a Macro that replaces the character '*' with the
number 3650 in all cells of my excel file (though I don't need help with the
Macro part, just how to type the character to be replaced).

Thanks for your help!
I've been searching the help pages for over an hour with no joy.

Hello all,

1st time post, so apologies if it is in the wrong section etc.

I am attempting to write a formula to change a character in text, but only if it is present.

So, for example, the text is "AB1oABCD" it should be AB10ABCD [The o replaces with a zero]

The logic is something along the lines of 'If the 4th character is the letter o, replace it with the number 0, if it is not, then leave the text as it is'

i have tried using the LEFT and RIGHT functions to point an IF function at the 4th character, then if the IF says there is a o in the 4th character position, REPLACE is used to change it to a 0. I can't seem to get it to work. I would like to avoid VBA and macros if possible.

Can anyone help ?

Thanks in advance !

EDIT: Solved, well i think so, see my post further down.

I need to replace with a formatting command (like you can in Word). I could
set up a macro to do this if it is possible to go to the actual character
within the cells, rather than locating the whole cell.

I have data in a the workbook that contains an asterik in it. I want to
clear that character and leave the remaining ones (or replace it with
something). But a * is considered a wildcard character that signals Excel to
grab everything. How do I find and replace just that?

Hi,

This must be a common issue. I'd like to replace/remove the LineFeed character (a type of square) in an Excel file. How can I do that?

Cheers

Hi,
One of the columns in my excel has its content broken into lines. I
guess each line within that column ends with a carrieage return and
line feed.

how can I replace these with say a "-" character? I was trying to use
Find and Replace but don't know how to enter the CRLf character and if
I use Alt 13 and / or Alt 10 (for cariage return and line feed) it
wont fine these.

Any help will be appreciated

Hello everyone,

i am trying to find a way to replace static numbers to other numbers i want,

for example :
http://img404.imageshack.us/img404/5886/3sq5.jpg

I want to replace all the 1's to 6 without rewriting each number because the
chart is way too big and it will take me ages to complete that , is there a way to automate this process ?

Thanks in advance !

Hi there,
I have a problem that I need help from the more knowledgable people here.

I need something to replace the last digit in a number sequence with a character.

There are some conditions:

1. This only happens if the number is negative.
2. The last digit is replaced by a different character depending on what the digit is.

So if 1=A and 2=B and 3=C etc etc then
-6546448491 becomes 654644849A
-4562 becomes 456B
-988789788.13 becomes 988789788.1C

Help???????

Dear Experts,

Can some one give me vba code to replace only one character from string.

For example:

My - Name - is - Ali

*remove the first "-" only and replace it by "/"

so the result will be, My / Name - is - Ali.

Thanks