Unique Trimming of cell

[cooper1308]

Have about 5000 cells in the following format:

Vol / Avg. 15,372.00/7,000.00

What I need is a function to trim everything, except for the figure on the right of the second ( / ) .....I can't trim say 5 numbers from the right as this figure will always have a different amount of characters.

Thx

[DonkeyOte]

One way, if your string is in A1 then

B1: =0+REPLACE(A1,1,FIND("#",SUBSTITUTE(A1,"/","#",2)),"")

[mubashir aziz]

Vow DK i was working on a long formula but before sending i just refresh and your exceptional formula was there. So my formula is with me now

[cooper1308]

One way, if your string is in A1 then

B1: =0+REPLACE(A1,1,FIND("#",SUBSTITUTE(A1,"/","#",2)),"")

GENIUS!!

I have one problem

Just to be difficult, some of the cells are format like this:

Vol / Avg. 932,752.00/1.46M

So i'm getting the #VALUE for amounts that are in the millions..

Is there another function to combat this? I could open two columns on the right of the cell and run each next to eachother then somehow combine.

Again really appreciate the help.

Cheers

[DonkeyOte]

remove the 0+ ... the results will obviously not be numbers but you should not get any errors.