Spy Journal 3.0 Filtering the web for you

This week we will look at some text functions. FIND and SEARCH are essentially the same function with only minor differences.

These functions both allow you to search through a text string (think sentence or word or phrase) in a cell and return the number of the starting character. So when cell A1 has The quick brown fox, =FIND(“fox”,A1) would return 17.

The following screenshots indicate the function arguments and explain the functions syntax.

I have had so much new stuff come over my desk the last few days I haven’t got time to try it or even review it properly. There is a lot of new innovative things going on at the moment on the web.

Here is a randomly ordered selection of stuff that I thought was cool or useful.

Large File Sharing Services

(also added to my original large file sharing post)

Pando is free P2P software that makes downloading, streaming and sharing large media files fast, easy and fun. Need to email large attachments, IM a folder, or publish your downloadable videos to the Web? Maybe you'd just like to watch full-screen HD Internet TV. Meet Pando.

Microsoft Office Live Workspace Beta

Save your documents to the Web—for free!

Access files from anywhere

• View documents from almost any computer with a Web browser
• No more flash drives—files are there when and where you need them
• Password-protected sharing; you control who views and edits your work

Work with programs you know

• Save over 1,000 Microsoft Office documents in one online place
• Open and save files from familiar programs like Word, Excel, and PowerPoint
• Synchronize contact, task, and event lists with Outlook

Free Photo Shop tutorials at Luxa

SkyScanner is a Flight Search site that works for other countries than US.

The MOD function is very useful in certain circumstances.

The function returns the integer remainder after a number has been divided by a divisor. For example if you divide 10 by 3, it goes in 3 times with one remaining.

Since 1991, the Professional Developers Conference (PDC) has been Microsoft’s premier gathering of leading-edge developers and architects.

There has been a lot of news blogged from this conference over the last few days.

I have summarised and provided links for the main things from my perspective as it affects me, our business and our clients. Some of this stuff wont impact our clients for several years, but its nice to be able to see glimpses of the future.

Live Mesh

Live Mesh shifted from Tech Preview to Beta in the last few days as we indicated a few days ago it would. However there was lots of good stuff talked about the mesh platform at PDC. Some of these links are about the new features in Beta and some are blogs from PDC.

From Sarah Perez: