Subscribe to CCI PRO and support your CAclubindia community. Click Here!
caclubindia logo
  • News
    Income Tax GST Students Corporate Law Audit More ...
  • Articles
    Income Tax Students GST Corporate Law Service Tax More ...
  • Forum
    Income Tax Students GST Corporate Law Accounts More ...
  • Experts
    Income Tax Students GST Service Tax Accounts More ...
  • Notices
    Customs Income Tax GST Corporate Law Shares and Stock More ...
  • Files
    Income Tax Students GST Corporate Law Accounts More ...
  • Judiciary
    Income Tax LAW GST Corporate Law Service Tax More ...
  • Learning
  • Books
  • Jobs
CCI Pro Sign In 
Site
Course
Site
Course

Certification Course on Practical Filing of Income Tax Returns

CA Pratibha Goyal   INR 799

Excel Mastery Program

CA Rishabh Pugalia   INR 1999

Live Session on JDA Transactions in Real Estate

CA Vishal G Poddar   INR 499

Certification Course on Chat GPT and AI Tools for Professionals

CA Deepak Gupta   INR 399
Close
  • Popular Courses
  • LIVE
  • GST
  • Tally
  • Excel
  • MsOffice
  • Income Tax
  • Accounting
  • CA
  • CS
  • EPF Live Course
  • More classes
  • Courses :
  • Live
  • EPF Live Course
  • View All
  1. Home
  2. Forum
  3. Info Technology
  4. Excel

Excel tips : replacing dashes with periods

PRAVEEN KUMAR

PRAVEEN KUMAR (MBA (Finance) B.Com.(P))   (3443 Points)

26 November 2011  

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.



Reply

Follow

Share

More
  •   Start a discussion
  •   Unanswered
  • Report Abuse

 3 Replies

CA Ayush Agarwal

CA Ayush Agarwal (Kolkata-Pune-Mumbai) (27214 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 .

Online classes for CA CS CMA. Professional courses for GST, Tally, Others & Books
Upgrade to CAclubindia Pro. Subscribe Now!

HS Negi

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

CA Aniruddha A Ghude (Partner- Kohale Ghude & Associates)   (51 Points)
Replied 13 December 2011

AYUSH AGRAWAL

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



Leave a reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Join CCI Pro

Recent Topics


  • New ITR FORMS 1 AND 4
  • Changes in Form 15G and 15H, if any?
  • Is Exam / Certification fee of directors allowed a
  • Converting a Partner to Nominal Partner – Ze
  • GST on labour charges in respect of manufacturing
  • AIS not able to access
  • GST Input Related Query for Cab Services
  • Sale of Assets of Partnership firm
  • Suggest a fasttrack class for CA Inter costing for
  • Single Invoice for Sand and Jally above 1 Lakh Ewa

More recent discussions | Post

Related Threads


Loading

Popular Discussion


    Loading please wait

view more »


Start a New Discussion
CCI Pro

Trending Online Classes

  • Live Course on EPF & ESI Act - Mastercourse(With Govt Certificate)

    Mr.Balamurugan Ranganathan
    Mr.Balamurugan Ranganathan
    Enroll Now
    16 June 2025
  • Guide to UAE Corporate Tax Return filing (3rd Live Batch)

    CA Mohd Asim
    CA Mohd Asim
    Enroll Now
    14 June 2025
  • Professional ITR Preparer Course

    Saniya Mushrif
    Saniya Mushrif
    Enroll Now
    31 May 2025
view all classess


Subscribe to the latest topics :

Search Forum:

Forum Home
Popular Threads
Recent Posts
Unreplied Threads
Post New Topic
Settings



  • Articles
  • Forum
  • Jobs
  • Judiciary
  • Settings
  • News
  • Experts
  • Share Files
  • Notification
  • Certification Courses
  • Categories
  • Feed
  • Bookmarks
  • Top Members
  • CCI Rewards
  • Live Classes
  • Books
  • CCI Learning
  • Group
  • CCI Pro
Member Strength 4184036 and growing..
Find Us On

  • About
  • We are Hiring
  • Media Coverage
  • Advertise
  • Terms of Service
  • Disclaimer
  • Privacy Policy
  • Contact Us
© 2025 CAclubindia.com. India's largest network for Finance Professionals
Share
 Facebook
 Twitter
 Linkedin
 Reddit
 Email
 Whatsapp
 Gmail
 Pocket
 Print
 Pinterest
 PDF
 Translate
Whatsapp Groups
GST
Income Tax
CA Final
CA Inter
CAclubindia
Login at CAclubindia

cciCAclubindia

India's largest network for
finance professionals



login
Forgot Password ?

Alternatively, you can log in using:

Login with Facebook
Login with Google

Don't have an account? Register Now

click here to register