1. 

   Shekhar
   

   Member
   Joined: Oct '11
   Posts: 1

   i hv a coulumn containing data with slash I want it to remove from numeral and alphabets.
   please help

   Posted 8 months ago #
2. 

   bobhc
   

   Excel Ninja
   Joined: Jan '12
   Posts: 1,425

   Good day Shekhar

   Just use the find replace, find a forward slash and replace with nothing ie delete it and do for all in the work sheet

   Posted 8 months ago #
3. 

   Faseeh
   

   Excel Ninja
   Joined: Jan '12
   Posts: 1,585

   Hi,

   Few more tips:

   1. If your data have multiple slashes like 8/12/2012/2000/1111/AAA you can simply use substitute:

   =SUBSTITUTE(A1,"/","")

   2. If you have got this data as Date then:

   a) You can Custom Define Cell Format like (Right Click > Format Cells> Custom)& set as mmddyyyy

   b) You can use another formula with dates:
   =TEXT(A1,"MMDDYYYY")

   Regards,

   Posted 8 months ago #
4. 

   HARRY
   

   Member
   Joined: Sep '12
   Posts: 34

   CONTROL+H FIND / AND REPLACE WITH LEAVE BLANK..ENTER

   Posted 8 months ago #

RSS feed for this topic

Reply

You must log in to post.

Welcome to Chandoo.org. New here?

Thank you so much for visiting us & taking first step to become awesome in Excel. Please use below links to navigate our site.

Learn Excel - Topics » Excel for Beginners - Tutorials » Excel Formula Examples » Array Formulas » Excel Charts » Pivot Tables » Project Management using Excel » Excel Dashboards » Excel VBA » Advanced Excel

Our Products Full Training Programs » Excel School » Excel Dashboard Classes » Excel VBA Classes » Excel Financial Modeling » Excel for PMs Crash Courses » Excel Formula Course » Excel Dashboards Course Downloads » Excel PM Templates » Excel Formula E-book

About us » About Chandoo.org » Welcome » Best of Chandoo.org » FREE Excel Downloads » Contact Details » Excel Forums