I finally figured out using the LEN function. There is a trailing non-printable character that is not visible that carried over from the web page. If I use the following: =VALUE(LEFT(A1,LEN(A1)-1)) I get the cell. Unfortunately, CLEAN does not work for this. Don't know how to generalize beyond this to remove all non-numeric characters regardless of where they are in the string - but I'm sure there are ways to do this using various find functions. At any rate, that works for this data set where I can hard code that I only need to remove on character from the far right.

(According to the Excel CODE function, it is character(160), the non-breaking space, so I could also hard code that with SUBSTITUTE, which would be position independent. Generalizing it to all non-numeric characters would be a bit tougher, but I'm sure there is a way.)

Thanks -t for taking the time, and DX for your offer.

Glad you figured it out. Sorry I wasn't much help!

Well you really were. Your not being able to figure it out told me it was not just a combination of my being rusty in Excel and sleep deprived. Gave me the confidence to assume if I tried something and it failed, it was not just because I was doing it wrong. Then stuff sort of clicked. Just the confirmation that the problem was real and that I was not an idiot for not seeing it instantly was a big help.

Yeah, that makes sense. Glad it's working.

Don't know how to generalize beyond this to remove all non-numeric characters regardless of where they are in the string

While thinking about this, I did a search, and came up with this thread, whic towards the end has some code that might do what you want.

I am going to try seeing if the SSD is readable out of Smonster's water-dead Macbook Air (2010 model).

After that, I may try to replace the Mobo and power board for my own project.

Anyone have any spare parts for Macbook Airs? I'm hoping to find one with a smashed screen, but so far, prices are hella high for spare parts.

I guess I'm hesitant to take the $25-$40 plunge for just the power board just to see if it's the board, Board and Mobo, or just Mobo.

I have an iPad mini and the email has stopped working - it still displays, but I can't go from the message displayed to the in-box. Can't even delete the message displayed. It seems to be locked up completely, although it's displaying one new message.

I've tried turning the iPad off, backing it up, whatever I could think of. Any suggestions?

Have you tried using a different email app, like Outlook?

huh ... nope, hadn't thought of that - I figured since it was what came with the iPad, it was what you had to use with the iPad (sorry ... I've never used anything Apple before I got this ... mostly I use it to send photos of my manicures to a couple of friends)

Have you restarted the iPad? Hold down the power and home button until it reboots.

um ... which is the home button?