Home > IT Answers > Microsoft Windows > Excel formula to find and replace letters in a word
Microbert
25 pts.
 Excel formula to find and replace letters in a word
Find and Replace, MS Excel
Hi,
I have a cell that has a word written in it ex. damascus.
now with this formula i need to be able to find the "a" and replace it with "A".
so it will become dAmAscus.
is this possible?


Software/Hardware used:
Microsoft Excel
ASKED: February 10, 2010  4:03 PM
UPDATED: February 10, 2010  7:16 PM
RELATED QUESTIONS
Answer Wiki:
=substitute(cell#,"a","A") That would work just fine. Good luck.
Last Wiki Answer Submitted:  February 10, 2010  4:40 pm  by  carlosdl   63,535 pts.
All Answer Wiki Contributors:  carlosdl   63,535 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Hi

thanks for your answer. it really helped me

regards

Microbert
 25 pts.