If you have a need to normalize the appearance of your data, you might want to replace any dashes in a text string with periods. For instance, if you have a phone number such as "123-555-1212" you might want to change it to "123.555.1212". This is easy to do using the SUBSTITUTE function:
=SUBSTITUTE(A7,"-",".")
The result is that any dashes appearing in the string in cell A7 are replaced with periods.
Also I Suggest One Laymen Concept. to Do This.
Just Select Portion From Which You Wanna to Change.
Then Ctrl+H Replace Option.
Simple & Any One Can Do This .
Mr. Ayesh is correct . Generally we use replace option more in comparision to formula option.
Best Regards
HS Negi
AYUSH AGRAWAL
u r right man. easy and perfect way for replacement.
VIKAS VERMA & CO
New Delhi
Others
View Details
Triveni Turbine Limited
Bengaluru
CA
View Details
BHUPINDER SHAH AND COMPANY
New Delhi
CA Inter
View Details
SKAA & Associates
New Delhi
CA Inter
View Details
Interactive Media Pvt Ltd.
New Delhi
CA Inter
View Details
CAclubindia
