• C++ Programming for Financial Engineering
    Highly recommended by thousands of MFE students. Covers essential C++ topics with applications to financial engineering. Learn more Join!
    Python for Finance with Intro to Data Science
    Gain practical understanding of Python to read, understand, and write professional Python code for your first day on the job. Learn more Join!
    An Intuition-Based Options Primer for FE
    Ideal for entry level positions interviews and graduate studies, specializing in options trading arbitrage and options valuation models. Learn more Join!

Formatting Problem

Joined
4/18/08
Messages
2
Points
11
I have a question on a specific problem I am having with formatting in excel. I have couple hundred excel cells that are formatted like example DVAT-PIC1-07-06-01. How can I change them to DVATPIC1070601 without having to do it manually? Any help would be great. Thanks.
 
That shouldn't be difficult.
Highlight the column you want to convert. Select Find "-" and Replace by an empty cell. And then Replace All. Hope that helps.
 
Back
Top