Text to column deletes second numerical with "/"

i.e. 960/965
Text to column shows only 960.

What to do?

Thanks for Help.


On Wednesday, November 7, 2012 1:59:30 PM UTC+5:30, Claus Busch wrote:
Hi,



Am Wed, 7 Nov 2012 00:16:57 -0800 (PST) schrieb Gautam Bhut:



Hey this is not showeing average of both numerical.

i.e. for 960/965 - the formula gives 592.5.



I don't know, what is wrong. In my workbook I get the result 962.5



And if I use text to columns than what to do next for 960 965?



=IF(A1="","",AVERAGE(A1,B1))





Regards

Claus Busch

--

Win XP PRof SP2 / Vista Ultimate SP2

Office 2003 SP2 /2007 Ultimate SP2