Excel – more than just numbers!

From Exelkungens awesome website
If you ask a random person what Excel is for something, you get probably the answer “It is a spreadsheet program”! Thus understood a program that is all about numbers and calculations.

But the fact is that many of us Excel users as frequently working with text in our spreadsheet. It could for example, include lists of names, product names, and so on.

It provides this with text handling in Excel is essential if you want to work really effectively. By you master the most important text formulas in Excel, you can quickly and easily “magic” with the amounts of text anywhere in Excel.

Text management is essentially about two things:
1: to break out text (extract),
2: to format text.

Extraction of text in Excel:

This means that, through a formula, pick a certain part of the text content in a cell.
We assume that cell A1 contains the text “sirapslimpa”.

Formula Result
LEFT(A1;5) “syrup”, i.e., the five characters vänstersta
RIGHT(A1;6) “clean”, i.e., the first five characters High
MID(A1;7;3) “lim”, ie three characters fr o m the seventh character

The Swedish version is called the Excel instead LEFT, RIGHT and MID.

Text formatting in Excel

Furthermore, you can conjure with uppercase and lowercase letters.
We assume that cell A1 contains the text “Donald Duck”.

Formula Result
UPPER(A1) “DONALD DUCK”
LOWER(A1) “donald duck”
PROPER(A1) “DONALD DUCK”

The Swedish version is called the Excel instead CAPITALS, LOWER and INITIAL.

Be Careful Out There
Anders