is it always after the last space in the cell?

it was, what's the eitza for that?

=IF(ISERROR(FIND(" ",A1)),A1, RIGHT(A1,LEN(A1) - FIND("|",SUBSTITUTE(A1," ","|",LEN(A1)-LEN(SUBSTITUTE(A1," ",""))))))

" "

How would I create a starwood calculator, such that if I say I need, say 80,000 miles, it'd spit out to transfer 65,000 SPG?

=(ROUNDDOWN(A1/25000)*20000)+MOD(A1, 25000)

Something like this?Code: [Select]=(ROUNDDOWN(A1/25000)*20000)+MOD(A1, 25000)

=ROUNDDOWN(T10/25000,0)*20000+MOD(T10,25000)

Ding, ding, ding. Gracias.Though it had to be slightly modified:Code: [Select]=ROUNDDOWN(T10/25000,0)*20000+MOD(T10,25000)

Just closed an unsaved workbook I go to the recovery location and there is a weird file there, I try opening in excel but it just opens a blank spreadsheet with no cells. Is there any hope?

can you find the auto saved version? Should be something like file/recent/recover unsaved workbooks

I just add a ' anytime that happens to me