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.
Chirag P Shah & Co. Chartered Accountant
Pune
B.Com
View Details
Anupam Parashar & Co.
Ghaziabad
CA Final
View Details
CA Suraj Garg & Associates
New Delhi
CA Final
View Details
CCI
Pro
CAclubindia
