Jun 26 2007

Excel Length Formula

The Excel Length formula is a useful formula that can be used in many different circumstances. I’ll be showing a few of the useful examples of it below. But first let’s take a look at the formula itself:
LEN(text)
where text is any string you want to find the length of. This formula is really easy to [...]

May 2 2007

Left, Right and Mid Formulas in Excel

One of the easiest ways to manipulate a string is by using the left, right and mid formulas. There are many times when users of excel are given a long string and only need a certain section of that string to get the results they desire. Using these formulas will greatly reduce the number of [...]

XLAutomation
Easily design MySQL databases as familiar spreadsheets in Micros
Get Expert Excel Help Today! 714.262.6893
Get Expert Excel Help Today! 714.262.6893

Categories

Excel Poll of the Week

How often do you use Excel macros (VBA)?

View Results

Loading ... Loading ...