PRAVEEN KUMAR (MBA (Finance) B.Com.(P)) (3443 Points)
26 November 2011The result is that any dashes appearing in the string in cell A7 are replaced with periods.
CA Ayush Agarwal
(Kolkata-Pune-Mumbai)
(27186 Points)
Replied 26 November 2011
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 .
HS Negi
(Senior Executive- F&A)
(590 Points)
Replied 05 December 2011
Mr. Ayesh is correct . Generally we use replace option more in comparision to formula option.
Best Regards
HS Negi
CA Aniruddha A Ghude
(Partner- Kohale Ghude & Associates)
(51 Points)
Replied 13 December 2011
u r right man. easy and perfect way for replacement.
CAclubindia
