Excel tips : replacing dashes with periods

Excel 1175 views 3 replies
User Avatar

MBA (Finance) B.Com.(P)
3443 Points Joined March 2007

Excel Tips : Replacing Dashes with Periods

 

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.

1 Reply Share Follow
On 26 November 2011 at 16:16 Report
Replies (3)
User Avatar

Kolkata-Pune-Mumbai
27354 Points Joined October 2007

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 .

Reply
On 26 November 2011 at 16:58
User Avatar

Senior Executive- F&A
590 Points Joined January 2009

Mr. Ayesh is correct . Generally we use replace option more in comparision to formula option.

Best Regards

HS Negi

Reply
On 05 December 2011 at 15:55
User Avatar

Partner- Kohale Ghude & Associates
51 Points Joined April 2009

AYUSH AGRAWAL

u r right man. easy and perfect way for replacement.

Reply
On 13 December 2011 at 15:36


CCI Pro

Leave a Reply

Post Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Recent Threads

More recent discussions | Post

Related Threads
Loading