Excel Help and Problems

[churnbabychurn]

is it always after the last space in the cell?

it was, what's the eitza for that?

[smurf]

it was, what's the eitza for that?

this formula

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

by replacing "A1" with the correct cell reference
also you can replace the

" "

(the reference to spaces) with any character you want and it'll pull all data after the last occurrence of that character
Basically its a reverse find function

[AJK]

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?

[BAHayman]

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?

Something like this?

Code: [Select]

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

[AJK]

Something like this?

Code: [Select]

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

Ding, ding, ding. Gracias.

Though it had to be slightly modified:

Code: [Select]

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

[BAHayman]

Ding, ding, ding. Gracias.

Though it had to be slightly modified:

Code: [Select]

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

Ah, good to know. In Google Spreadsheets the second parameter for ROUNDDOWN is optional, which is why I use that over FLOOR(<value>, 1).

[AJK]

Figured you might have been using Sheets.

For anyone who is curious:

[churnbabychurn]

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?

[smurf]

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

[yitzf]

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

In 2013 its Backstage>Info>Versions

[churnbabychurn]

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

It turns out that if the workbook was never saved/named it doesnt auto save as a different versions. It doesnt have a version of a unnamed doc...
I went to the C:\Users\CBC\AppData\Roaming\Microsoft\Excel\ the file wasnt there....

Anywho, I did the work again, better than version one 

[katherine123]

I'm trying to make address labels but when I merge in word it keeps dropping the "0" in zip codes starting with "0". I can't find a fix online- does anyone know what I need to do?

[chucksterace]

I just add a ' anytime that happens to me..

And posting in already existing thread may help - http://forums.dansdeals.com/index.php?topic=35830.60. Please search before opening a new thread.

[etech0]

I just add a ' anytime that happens to me

+1

[katherine123]

I just add a ' anytime that happens to me

Won't that print as '08701? That doesn't look right...

[chucksterace]

Won't that print as '08701? That doesn't look right...

Don't think so. Just did a test run, print to PDF and came out good

ETA: Or you can go add a custom number, (where you would choose date, number, currency, etc) and just put in "00000" that way the minimum in the box would be five numbers and the zero would show.

[myb821]

or set it as text

[etech0]

Won't that print as '08701? That doesn't look right...

Nope - I do it all the time. Funny how this issue only comes up with lakewood

[chucksterace]

Nope - I do it all the time. Funny how this issue only comes up with lakewood

Oh well. Good thing I don't live in lakewood 

[katherine123]

Thank you all, it worked! Two nights of frustration solved within 5 minutes thanks to DDF.