take the last value before space in excel

[chadbrooks1980]

hi is there a way to take the last value from one cell and enter into another cell?

for example: if cell A1 had the follow
"<TABLE style="WIDTH: 452pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=602><COLGROUP><COL style="WIDTH: 452pt; mso-width-source: userset; mso-width-alt: 22016" width=602><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 452pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=20 width=602>09/01 Card Purchase 08/30 Cafe Sevilla Riverside Riverside CA Card 9540 $288.28</TD></TR></TBODY></TABLE>"
I'd like to have cell A2 grabe the value $288.28

Thanks!

Chad

 

[T. Valko]

hi is there a way to take the last value from one cell and enter into another cell?

for example: if cell A1 had the follow
"<TABLE style="WIDTH: 452pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=602 border=0><COLGROUP><COL style="WIDTH: 452pt; mso-width-source: userset; mso-width-alt: 22016" width=602><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 452pt; BORDER-BOTTOM: #f0f0f0; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" width=602 height=20>09/01 Card Purchase 08/30 Cafe Sevilla Riverside Riverside CA Card 9540 $288.28</TD></TR></TBODY></TABLE>"
I'd like to have cell A2 grabe the value $288.28

Thanks!

Chad

Try this...

=--TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",100)),100))