Special char in my data creating problem

[ROHAN999]

I am attching here with my sample sheet with sample of data and required result and plz provide me formula to suit my need

thanks in advance

[hemesh]

hello Rohan, how many types of special character are in your sheet can you list them

[hemesh]

=IFERROR(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2,".",""),"-",""),"/","")+0,"") try this in case your data is numeric, if non numeric then remove 0

[ROHAN999]

These are basically ./-,_ these are the commonly occured ....rest can be ignored..if i could get a formula for every special character would be wonderful else above said are important to atke care..kindly see my sample plz to understand it better

[hemesh]

=IFERROR(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2,".",""),"-",""),"/",""),"_","")+0,"") try this

[ROHAN999]

I understood your formula but sir kindly teach me +0 has been used for what purpose

and will this take care that after replacing the specail characters it provides value of that in number without decimal point

(in formatting i will take care)

[ROHAN999]

Thanks alot hemesh for your prompt replies...should i now try it finally

[hemesh]

Rohan, whenever you apply this formula numeric values will get converted to text so convert them back to numeric values.

If this helps click" * " and mark thread as colved

[ROHAN999]

That excel itslf is taking care thank you very much...

[ROHAN999]

Else i am going to put =value(iferror(substitute(substitute(substitute(substitute(a2,".",""),"-",""),"/",""),"_","")+0,"")) will it be ok

[ROHAN999]

THIS THREAD IS SOLVED

THANK YOU VERY MUCH FOR YOUR PROMPT ATTEMPT AND SOLUTION

CAN YOU HELP ME IN EITHER OF MY THREAT

http://www.excelforum.com/excel-prog...-of-excel.html

[ROHAN999]

THIS THREAD IS SOLVED

THANK YOU VERY MUCH FOR YOUR PROMPT ATTEMPT AND SOLUTION

CAN YOU HELP ME IN EITHER OF MY THREAT

http://www.excelforum.com/excel-prog...-of-excel.html

http://www.excelforum.com/word-forma...onversion.html

if you can it would be great!

Thank you

[hemesh]

To mark thread as solved go to thread tool ----> and mark thread as solved.

[hemesh]

Rohan I have checked the thread but unfortunately I am not a coding guy.

[hemesh]

Thanks for the Rep.

[ROHAN999]

Its ok hemesh..kindly refer my threats to somebody who is good in coding and known to you