How to remove few texts from a cell

[Feroz90]

Hi All,

How to remove few texts from a cell and list down the values in separate cells

Example: 1 of 100 1 of 200 1 of 500

I want to remove the "1 of" from the cell and list down the values in horizontal position one by one as

A2 = 100
A3 = 200
A4 = 500

Can anyone please help.

Thanks

 

[Fluff]

In that case can you please show exactly what is in the cell?

 

[Feroz90]

There is nothing, we have B2 = 300, B3 = Empty, B4 = 100.

 

[Fluff]

What is in A2, or whatever cell you are looking at?

 

[Feroz90]

A2 = 1 of 300 1 of 100

 

[Fluff]

With that in A2 I get

Book1
	A	B
2	1 of 300 1 of 100	300
3		100
Bid

 

[Feroz90]

It works, looks like some thing was in it, so I used trim option.

 

[Fluff]

Glad it's sorted & thanks for the feedback