Hi,

Am Tue, 6 Nov 2012 23:43:57 -0800 (PST) schrieb Gautam Bhut:

I have data in column like this.
50
50/152
[Blank]
56
150/150
20
[Blank]

I want only single numerical or blank in cell. For that I need average of 50/152.

try:
=IF(A1="","",IF(ISNUMBER(FIND("/",A1)),(LEFT(A1,FIND("/",A1)-1)+MID(A1,FIND("/",A1)+1,99))/2,A1))

or select your column = Data = Text to columns with delimiter "/".
Then you have to columns with clean data.


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2