Showing posts with label excel. Show all posts
Showing posts with label excel. Show all posts

Saturday, March 1, 2014

How can we find the position of letter in Excel ?

FIND


What Does It Do?

This function looks for a specified letter inside another piece of text.
When the letter is found the position is shown as a number.
If the text contains more than one reference to the letter, the first occurrence is used.
An additional option can be used to start the search at a specific point in the text, thus
enabling the search to find duplicate occurrences of the letter.
If the letter is not found in the text, the result #VALUE is shown.

Syntax

 =FIND(LetterToLookFor,TextToLookInside,StartPosition)

LetterToLookFor : This needs to be a single character.
TextToLookInside : This is the piece of text to be searched through.
StartPosition : This is optional, it specifies at which point in the text the search should begin.

Formatting

No special formatting is needed, the result will be shown as a number.



Friday, July 8, 2011

How to convert MS Excel to PDF or XPS ? & MS WORD to PDF or XPS

Microsoft Save as PDF or XPS

There are many situations where it is useful to save your file in a fixed-layout format that is easy to share and print and hard to modify. Examples of these situations include resumes, legal documents, newsletters, and any other file that is intended to be primarily read and printed. The 2007 Microsoft Office system offers a free add-in to save or export this type of file, but you must first install the add-in before you can use it. Other third-party products may also be available to export a Microsoft Office file into a fixed-layout document.

By using an add-in, you can save or export a file from your Microsoft Office program into the following formats:

Portable Document Format (PDF) PDF is a fixed-layout electronic file format that preserves document formatting and enables file sharing. The PDF format ensures that when the file is viewed online or printed, it retains exactly the format that you intended, and that data in the file cannot be easily changed. The PDF format is also useful for documents that will be reproduced by using commercial printing methods.

XML Paper Specification (XPS XPS is a fixed-layout electronic file format that preserves document formatting and enables file sharing. The XPS format ensures that when the file is viewed online or printed, it retains exactly the format that you intended, and that data in the file cannot be easily changed

It also allows you to send as e-mail attachment in the PDF and XPS formats in a subset of these programs

Refer link: http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=7

Twitter Bird Gadget