Read contents of a cell before and after "/" and display min and max

[sushilchandi]

Hi , I have a column which records the start and end bill numbers that I have made in a day with a slash between them .. e.g: 1/3 means that I have made bills 1,2,3 on that day .. I have a column where all this is recorded .. On top of that column I want a cell which tells me the start bill and end bill of the entire column .. Few cells can also be blank in this column.. I already have a macro which fills the column for me .. Can someone please help me with the first cell where I get 1/25 achieved with a worksheet function ..

	1/25
1 jan	1/3
2 jan
3 jan	4/7
4 jan	8/12
5 jan	13/25

<tbody>
</tbody>

 

[kevatarvind]

try below

Excel Workbook
	A	B	C
1	1/25	1	25
Sheet1

 

[sushilchandi]

yes this is for a single cell .. but I want this to be applied on an entire column where there can be black rows .. i.e. the entries already exist I only want a function to go through the entire column and give me :min value / max value of the column

 

[kevatarvind]

Copy paste formula to entire colomn