Excel Question: Is it possible to delete all text from a column without deleting the numbers?

Asked by Last Modified  

Follow 1
Answer

Please enter your answer

Computer Trainer

Yes we can use some conditions over there.
Comments

Yes u can use =subtitute() function for the same.??
Comments

Related Questions

What is the one formula that you can never use in an excel?
First we need to differentiate between FORMULA and FUNCTION before answering the question. Formula is anything that starts with "=" sign. Like =3+9. However, function is a subset of formulas, and they...
Raja
What are the best practices when modelling in Excel?
Best Practices for Modelling in Excel: Know your Tool which is excel in this case. Avoid Circular Referencing Have a Glossary for your model which states what means what Use same theme and formatting...
Ajay
1 0
6
I am looking to learn immediately Advanced Excel & VBA Macros. Please provide the Institute contact details and tutor availability in week ends ( Sat- Sun) .
Hi Pratap, Would you please let me know your educational background as to know VBA Macros , you must have good hands on Programming...and if you are novice or not from it background then I suggest you...
Prathap
Hello, I would like to attend training for getting updated with the latest features in MS PowerPoint, can you suggest best online coaching for this?
If you are staying in mumbai I can help you. I was corporate,trainer of Microsoft. I taught more than 5000 professionals on MS products. If you are interested you can contact me.
Naren

Now ask question in any of the 1000+ Categories, and get Answers from Tutors and Trainers on UrbanPro.com

Ask a Question

Related Lessons

What is a VBA Module?
VBA code is stored and typed in the VBA Editor in what are called modules As stated on the VBA Editor page, a collection of modules is what is called a VBA project Every major Microsoft Office product...

How to add a diagonal line in a cell in MS EXCEL
Many a times we feel the need to use a cell to act as headers for data flowing in two directions -- Rows and columns and for this purpose we may want to add a diagonal line to accomodate the two headers...

Data Analysis with MS Excel Filter - Top Performers, Bottom Performers, Above Average Performers, Below Average Performers!
In the following, You would find lesser-known, unexplored yet Powerful Features of Filter. Please refer to sample dataset below: To do Data Analysis:Step 1) Apply Filter on the dataset.Step 2) In Sales...

Presentation Perfect Reports
Presentation Perfect Reports. Why Presentable, neatly crafted Reports makes a job more perfect and easy for Business Analyst who is going make decisions out of the information structured in reports. Many...

VBA Tip: Repeating Emp Names N number of times using 4 different loops
Hi All,This is a requirement from one of our student and here we are posting the question along with solution (this can be achieved using 4 different loops). In Column “J” there are few employee...

Recommended Articles

Almost all of us, inside the pocket, bag or on the table have a mobile phone, out of which 90% of us have a smartphone. The technology is advancing rapidly. When it comes to mobile phones, people today want much more than just making phone calls and playing games on the go. People now want instant access to all their business...

Read full article >

Microsoft Excel is an electronic spreadsheet tool which is commonly used for financial and statistical data processing. It has been developed by Microsoft and forms a major component of the widely used Microsoft Office. From individual users to the top IT companies, Excel is used worldwide. Excel is one of the most important...

Read full article >

Whether it was the Internet Era of 90s or the Big Data Era of today, Information Technology (IT) has given birth to several lucrative career options for many. Though there will not be a “significant" increase in demand for IT professionals in 2014 as compared to 2013, a “steady” demand for IT professionals is rest assured...

Read full article >

Applications engineering is a hot trend in the current IT market.  An applications engineer is responsible for designing and application of technology products relating to various aspects of computing. To accomplish this, he/she has to work collaboratively with the company’s manufacturing, marketing, sales, and customer...

Read full article >

Looking for MS Office Software Training ?

Learn from the Best Tutors on UrbanPro

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you