replace data containg slash '/' eg 08/12/2012 into 08122012

[Shekhar]

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

please help

 

[bobhc]

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

 

[Faseeh]

Hi,


Few more tips:


1. If your data have multiple slashes like

8/12/2012/2000/1111/AAA you can simply use substitute:


[code]=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&#34[/code]


Regards,

 

[HVK1986]

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