Replies

There are 360 degrees in one circle. There are 2*pi radians in circle. Thus
Degrees = Radians / (2*PI()) *360 or

Degrees = 180 * Radians / PI()

Steve

Within Excel of course, you can use the formula =DEGREES(A1) to convert A1 in radians into Degrees
=RADIANS(B1) does the opposite conversion.

If I could access my files on C: it would be easy to copy them to my W7 partition, but access is restricted.

There are a number of Linux versions that you can run from a CD (without going as far as a full instal) and they should give you the ability to copy files and folders from your C drive.
Knoppix is one, DSL (Damn Small Linux) another.

Check your Gmail settings for any filters and redirects that may have been set up too. There was a report in a UK newspaper about someone whose Gmail account was hacked and a filter added that redirected any emails from his bank. The hacker was then able to use the person’s online account to remove money from his account without his knowledge.

That’s a sympton of a backlight failure. This can be one of three problems:

1. The CCFL (cold cathode fluorescent lamp) has failed (most common)
2. The power inverter for the CCFL has died – CCFLs are high voltage, low current devices (also common)
3. The ribbon connector passing the power from the main case to the screen has dislodged (not that common but possible)

For a competent DIYer, 3 is easy to find and reattach. Replacing the CCFL is also quite easy and if you search Google, you’ll find many suppliers of replacement lamps – quite inexpensive to replace. Replacing 2 is slightly more tricky but much more expensive and probably not worth the outlay.

Replacing the inverter isn’t that expensive. I replaced the inverter for my HP laptop for less than £60 – It gave me a good 18 months extra life out of it, which I considered a reasonable return.

Yes, the values in column F are calculated. The value in F is the value in C x .007 (a screenshot with the formula is attached). If Excel is not rounding up the figures in rows 4 and 6 (2.695), what’s going on in row 8 (6.6325)? It’s giving 198.14 as the result of 204.78 minus 6.63, while in row 10 191.30 minus the same 6.63 equals 184.67?

Is it possible that automatic calculation has been switched off? Try hitting F9 and see if the calculations right themselves.

HI, I have about 5,000 rows of data. One of the columns currently contains 21 characters includes spaces, but I only want to have the last 8 characters. Is this called truncating and how do i do it?

brian

The simplest way is to use the following.
=RIGHT(A1,8)

Yes I did post on Eileen’s Lounge where my friend Hans resides now. Although a solution has been offered, it does not do the trick. All I would like to hear from Rory, or anyone for that matter, is how I can possibly get his UDF to work. Plain and simple! No hidden agendas here!

Does it need to be a UDF?

You could use a formula such as
=right(trim(A1),9)

I am not sure if this is where to ask this and I am not sure this is a Windows XP problem. When I go to Microsoft Office Discussion on the web, the area that displays the discussions is blank. I deleted cookies and temp files and history and when I did that once before, the discussion area became visible but now no matter what I do, the discussion area is blank. Has anyone encountered this problem? I just got a new computer so maybe there is a setting that is missing.

Have you downloaded a Java runtime? New windows computers no longer come with them as standard, so you need to download one before you can use some feature-rich sites

You can download a Java runtime from here

Firefox will connect for about 2 pages and then gives me a notice that “Firefox is currently off line and cannot browse the web”, from then on I get “server cannot be found” with Firefox and all the other browsers.

When I choose a wireless network, It says I’m connected but same sequence as described above occurs. Any ideas? BTW, an ethernet cable plugged in works fine. The router is a Linksys wrt310n, wireless n. I’ve used this router before, successfully.

Any suggestions would be great and thanks for the help.

Either the problem is with the router, or the laptop, or with the connection.

Have you tried

[*]connecting another computer?
[*]using another wireless router?
[*]using a different channel?

While on the road, I sometimes have to use a hotel’s business area computer to print airline boarding passes, hotel reservations, supershuttle reservations and the like, most of which usually show up in the PC’s browser as a web page. In addition to printing to paper, I would like to be able to save these documents to a .pdf file or .mht file and carry them on a thumb drive – just in case.

Generally, these web pages will not save as a web page. I am guessing because of the dynamic content

Does anyone have any ideas how to save these types of web pages? Thanks.

I was going to suggest this way of printing (it works for the iPad apparently).

A related alternative would be to take a photo of the screen with your digital camera.

We have a user who has two columns of user IDs which consist of letters followed by numbers (e.g., ABC1234, DE5678, JFK3346, IG4435, etc.). There are always four numbers at the end, but there may be two or three initials at the beginning, and there are no spaces in the IDs to serve as delimiters. He would like to be able to “replace” all the numbers in each column with nothing (strip the numbers), leaving him with just two columns of initials.

Is there a way to accomplish that in Excel? A formula? A macro? A split columns to text function? Something?

We know we can export the data to Word, run a find and replace, and then copy it back to Excel, but is there any way to do it completly in Excel?

Many thanks,

Karnie

If there are always 4 digits at the end, he could use the following formula

=LEFT(A1,LEN(A1)-4)

This is not the case!

Since we are using VLOOKUP with a 4th argument of 0 (same as false) then it does not matter what order the Lookup list is in.
It is only with the True 4th argument of VLOOKUP that order of the lookup reference column matters.

IF we tried to use the standard LOOKUP Function then that would have been a different matter.

Also IF you omit the 4th argument of VLOOKUP then it defaults to TRUE which is the Order Specific option.

Ooops, my bad. I never knew that
.
Live and Learn!

While on the road, I sometimes have to use a hotel’s business area computer to print airline boarding passes, hotel reservations, supershuttle reservations and the like, most of which usually show up in the PC’s browser as a web page. In addition to printing to paper, I would like to be able to save these documents to a .pdf file or .mht file and carry them on a thumb drive – just in case.

Generally, these web pages will not save as a web page. I am guessing because of the dynamic content

I have not been able to determine how to save/print/convert the web page to a .pdf file without installing a .pdf printer driver on the hotel’s PC, which, of course, is not such a great idea and in many cases, the hotel’s PC is locked down, making such installation impossible.

I have not been able to get a .pdf printer driver to install to a thumb drive.

Does anyone have any ideas how to save these types of web pages? Thanks.

I suppose if you had a no-install word processor on a usb drive you could Alt Print Screen the web page as an image and paste it into a document.

I’ve no recommendations for which word processor though.

Have a look at the attached Example to see if it helps.

Column E would have to be ordered “Exceeds, Meets, Needs Development” to ensure that the entries in Column A are in alphabetic order when being used for the Lookup.

I’m looking to change my router/modem (currently a Netgear DG834N) seems to have developed an intermittent connection with the internet.
So, can anybody recommend an ADSL wireless router please?

Don’t assume the problem is with the router – we had experienced dropouts on a daily basis (or more) for which we had to restart the router and, like you, we assumed that the problem was with the router itself. However, after 6 months of this we totally lost our Broadband service. After having a Pipex engineer come round and test the system he then pinned it down as a problem with the line from the exchange, and raised the call with BT.

A couple of days later a BT engineer came around and sorted the problem with the line and since then we’ve not had a single dropped connection.

On the strength of this, I’d suggest you see if you can borrow another router as it may be that the dropped connection problem is with the line rather than with your existing kit.

On the other hand, I’m not sure what sort of response you will get if it’s only an intermittent problem. It’s hard to get anyone to accept they exist.