Slide 1

Microsoft Office
Grade 10 A / B

13

Microsoft Excel – 04
Cahaya Bangsa Classical School
(C) 2010 Digital Media Production Facility

13 – Microsoft Excel - 04

OUTLINE

| 2

OUTLINE
•
•
•
•
•
•

Objective
Introduction
“&” Worksheet Function
“LEFT” Worksheet Function
“MID” Worksheet Function
“RIGHT” Worksheet Function

Cahaya Bangsa Classical School

Microsoft Office

(C) 2010 Digital Media Production Facility

13 – Microsoft Excel - 04

Objective

| 3

Understand Microsoft Excel
basic text manipulation formula with
“&”, “left”, “mid”, “right”
worksheet function

Cahaya Bangsa Classical School

Microsoft Office

(C) 2010 Digital Media Production Facility

13 – Microsoft Excel - 04

Introduction

| 4

Introduction
- Categorized as “Text” worksheet function
- Converts anything into text, including numbers
- However, arithmetic operation will transform any converted numbers
back to numbers.

Cahaya Bangsa Classical School

Microsoft Office

(C) 2010 Digital Media Production Facility

13 – Microsoft Excel - 04

“&” Worksheet Function

| 5

“&” Worksheet Function
- Purpose: to join cell content without special characters, including space
- Usages: as any other formula, always begin with “=“
follows by cell address
Example
A17 : cS4fG | C26 : 9f7ZKh
=A17&C26 will result cS4fG9f7ZKh

cell locking may applies
Cahaya Bangsa Classical School

Microsoft Office

(C) 2010 Digital Media Production Facility

13 – Microsoft Excel - 04

“LEFT” Worksheet Function

| 6

“LEFT” Worksheet Function
- Purpose: to grab cell content beginning from left to right
- Usages: as any other formula, always begin with “=“
=LEFT(cell address, #of characters)
Example
C16 : g4LkwS83
=LEFT(C16,3) will result : g4L

cell locking may applies
Cahaya Bangsa Classical School

Microsoft Office

(C) 2010 Digital Media Production Facility

13 – Microsoft Excel - 04

“MID” Worksheet Function

| 7

“MID” Worksheet Function
- Purpose: to grab cell content beginning from center to right
- Usages: as any other formula, always begin with “=“
=MID(cell address, start char #, #of characters)
Example
C16 : g4LkwS83
=MID(C16,3,2) will result : Lk
start from character #3 (k) then grab 2 characters (L and k)

cell locking may applies
Cahaya Bangsa Classical School

Microsoft Office

(C) 2010 Digital Media Production Facility

13 – Microsoft Excel - 04

“RIGHT” Worksheet Function

| 8

“RIGHT” Worksheet Function
- Purpose: to grab cell content beginning from right to left
- Usages: as any other formula, always begin with “=“
=RIGHT(cell address, #of characters)
Example
C16 : g4LkwS83
=RIGHT(C16,2) will result : 83 (as text, NOT number)

cell locking may applies
Cahaya Bangsa Classical School

Microsoft Office

(C) 2010 Digital Media Production Facility

13 – Microsoft Excel - 04

THANK YOU

| 9

THANK
YOU
Cahaya Bangsa Classical School

Microsoft Office

(C) 2010 Digital Media Production Facility


Slide 2

Microsoft Office
Grade 10 A / B

13

Microsoft Excel – 04
Cahaya Bangsa Classical School
(C) 2010 Digital Media Production Facility

13 – Microsoft Excel - 04

OUTLINE

| 2

OUTLINE
•
•
•
•
•
•

Objective
Introduction
“&” Worksheet Function
“LEFT” Worksheet Function
“MID” Worksheet Function
“RIGHT” Worksheet Function

Cahaya Bangsa Classical School

Microsoft Office

(C) 2010 Digital Media Production Facility

13 – Microsoft Excel - 04

Objective

| 3

Understand Microsoft Excel
basic text manipulation formula with
“&”, “left”, “mid”, “right”
worksheet function

Cahaya Bangsa Classical School

Microsoft Office

(C) 2010 Digital Media Production Facility

13 – Microsoft Excel - 04

Introduction

| 4

Introduction
- Categorized as “Text” worksheet function
- Converts anything into text, including numbers
- However, arithmetic operation will transform any converted numbers
back to numbers.

Cahaya Bangsa Classical School

Microsoft Office

(C) 2010 Digital Media Production Facility

13 – Microsoft Excel - 04

“&” Worksheet Function

| 5

“&” Worksheet Function
- Purpose: to join cell content without special characters, including space
- Usages: as any other formula, always begin with “=“
follows by cell address
Example
A17 : cS4fG | C26 : 9f7ZKh
=A17&C26 will result cS4fG9f7ZKh

cell locking may applies
Cahaya Bangsa Classical School

Microsoft Office

(C) 2010 Digital Media Production Facility

13 – Microsoft Excel - 04

“LEFT” Worksheet Function

| 6

“LEFT” Worksheet Function
- Purpose: to grab cell content beginning from left to right
- Usages: as any other formula, always begin with “=“
=LEFT(cell address, #of characters)
Example
C16 : g4LkwS83
=LEFT(C16,3) will result : g4L

cell locking may applies
Cahaya Bangsa Classical School

Microsoft Office

(C) 2010 Digital Media Production Facility

13 – Microsoft Excel - 04

“MID” Worksheet Function

| 7

“MID” Worksheet Function
- Purpose: to grab cell content beginning from center to right
- Usages: as any other formula, always begin with “=“
=MID(cell address, start char #, #of characters)
Example
C16 : g4LkwS83
=MID(C16,3,2) will result : Lk
start from character #3 (k) then grab 2 characters (L and k)

cell locking may applies
Cahaya Bangsa Classical School

Microsoft Office

(C) 2010 Digital Media Production Facility

13 – Microsoft Excel - 04

“RIGHT” Worksheet Function

| 8

“RIGHT” Worksheet Function
- Purpose: to grab cell content beginning from right to left
- Usages: as any other formula, always begin with “=“
=RIGHT(cell address, #of characters)
Example
C16 : g4LkwS83
=RIGHT(C16,2) will result : 83 (as text, NOT number)

cell locking may applies
Cahaya Bangsa Classical School

Microsoft Office

(C) 2010 Digital Media Production Facility

13 – Microsoft Excel - 04

THANK YOU

| 9

THANK
YOU
Cahaya Bangsa Classical School

Microsoft Office

(C) 2010 Digital Media Production Facility


Slide 3

Microsoft Office
Grade 10 A / B

13

Microsoft Excel – 04
Cahaya Bangsa Classical School
(C) 2010 Digital Media Production Facility

13 – Microsoft Excel - 04

OUTLINE

| 2

OUTLINE
•
•
•
•
•
•

Objective
Introduction
“&” Worksheet Function
“LEFT” Worksheet Function
“MID” Worksheet Function
“RIGHT” Worksheet Function

Cahaya Bangsa Classical School

Microsoft Office

(C) 2010 Digital Media Production Facility

13 – Microsoft Excel - 04

Objective

| 3

Understand Microsoft Excel
basic text manipulation formula with
“&”, “left”, “mid”, “right”
worksheet function

Cahaya Bangsa Classical School

Microsoft Office

(C) 2010 Digital Media Production Facility

13 – Microsoft Excel - 04

Introduction

| 4

Introduction
- Categorized as “Text” worksheet function
- Converts anything into text, including numbers
- However, arithmetic operation will transform any converted numbers
back to numbers.

Cahaya Bangsa Classical School

Microsoft Office

(C) 2010 Digital Media Production Facility

13 – Microsoft Excel - 04

“&” Worksheet Function

| 5

“&” Worksheet Function
- Purpose: to join cell content without special characters, including space
- Usages: as any other formula, always begin with “=“
follows by cell address
Example
A17 : cS4fG | C26 : 9f7ZKh
=A17&C26 will result cS4fG9f7ZKh

cell locking may applies
Cahaya Bangsa Classical School

Microsoft Office

(C) 2010 Digital Media Production Facility

13 – Microsoft Excel - 04

“LEFT” Worksheet Function

| 6

“LEFT” Worksheet Function
- Purpose: to grab cell content beginning from left to right
- Usages: as any other formula, always begin with “=“
=LEFT(cell address, #of characters)
Example
C16 : g4LkwS83
=LEFT(C16,3) will result : g4L

cell locking may applies
Cahaya Bangsa Classical School

Microsoft Office

(C) 2010 Digital Media Production Facility

13 – Microsoft Excel - 04

“MID” Worksheet Function

| 7

“MID” Worksheet Function
- Purpose: to grab cell content beginning from center to right
- Usages: as any other formula, always begin with “=“
=MID(cell address, start char #, #of characters)
Example
C16 : g4LkwS83
=MID(C16,3,2) will result : Lk
start from character #3 (k) then grab 2 characters (L and k)

cell locking may applies
Cahaya Bangsa Classical School

Microsoft Office

(C) 2010 Digital Media Production Facility

13 – Microsoft Excel - 04

“RIGHT” Worksheet Function

| 8

“RIGHT” Worksheet Function
- Purpose: to grab cell content beginning from right to left
- Usages: as any other formula, always begin with “=“
=RIGHT(cell address, #of characters)
Example
C16 : g4LkwS83
=RIGHT(C16,2) will result : 83 (as text, NOT number)

cell locking may applies
Cahaya Bangsa Classical School

Microsoft Office

(C) 2010 Digital Media Production Facility

13 – Microsoft Excel - 04

THANK YOU

| 9

THANK
YOU
Cahaya Bangsa Classical School

Microsoft Office

(C) 2010 Digital Media Production Facility


Slide 4

Microsoft Office
Grade 10 A / B

13

Microsoft Excel – 04
Cahaya Bangsa Classical School
(C) 2010 Digital Media Production Facility

13 – Microsoft Excel - 04

OUTLINE

| 2

OUTLINE
•
•
•
•
•
•

Objective
Introduction
“&” Worksheet Function
“LEFT” Worksheet Function
“MID” Worksheet Function
“RIGHT” Worksheet Function

Cahaya Bangsa Classical School

Microsoft Office

(C) 2010 Digital Media Production Facility

13 – Microsoft Excel - 04

Objective

| 3

Understand Microsoft Excel
basic text manipulation formula with
“&”, “left”, “mid”, “right”
worksheet function

Cahaya Bangsa Classical School

Microsoft Office

(C) 2010 Digital Media Production Facility

13 – Microsoft Excel - 04

Introduction

| 4

Introduction
- Categorized as “Text” worksheet function
- Converts anything into text, including numbers
- However, arithmetic operation will transform any converted numbers
back to numbers.

Cahaya Bangsa Classical School

Microsoft Office

(C) 2010 Digital Media Production Facility

13 – Microsoft Excel - 04

“&” Worksheet Function

| 5

“&” Worksheet Function
- Purpose: to join cell content without special characters, including space
- Usages: as any other formula, always begin with “=“
follows by cell address
Example
A17 : cS4fG | C26 : 9f7ZKh
=A17&C26 will result cS4fG9f7ZKh

cell locking may applies
Cahaya Bangsa Classical School

Microsoft Office

(C) 2010 Digital Media Production Facility

13 – Microsoft Excel - 04

“LEFT” Worksheet Function

| 6

“LEFT” Worksheet Function
- Purpose: to grab cell content beginning from left to right
- Usages: as any other formula, always begin with “=“
=LEFT(cell address, #of characters)
Example
C16 : g4LkwS83
=LEFT(C16,3) will result : g4L

cell locking may applies
Cahaya Bangsa Classical School

Microsoft Office

(C) 2010 Digital Media Production Facility

13 – Microsoft Excel - 04

“MID” Worksheet Function

| 7

“MID” Worksheet Function
- Purpose: to grab cell content beginning from center to right
- Usages: as any other formula, always begin with “=“
=MID(cell address, start char #, #of characters)
Example
C16 : g4LkwS83
=MID(C16,3,2) will result : Lk
start from character #3 (k) then grab 2 characters (L and k)

cell locking may applies
Cahaya Bangsa Classical School

Microsoft Office

(C) 2010 Digital Media Production Facility

13 – Microsoft Excel - 04

“RIGHT” Worksheet Function

| 8

“RIGHT” Worksheet Function
- Purpose: to grab cell content beginning from right to left
- Usages: as any other formula, always begin with “=“
=RIGHT(cell address, #of characters)
Example
C16 : g4LkwS83
=RIGHT(C16,2) will result : 83 (as text, NOT number)

cell locking may applies
Cahaya Bangsa Classical School

Microsoft Office

(C) 2010 Digital Media Production Facility

13 – Microsoft Excel - 04

THANK YOU

| 9

THANK
YOU
Cahaya Bangsa Classical School

Microsoft Office

(C) 2010 Digital Media Production Facility


Slide 5

Microsoft Office
Grade 10 A / B

13

Microsoft Excel – 04
Cahaya Bangsa Classical School
(C) 2010 Digital Media Production Facility

13 – Microsoft Excel - 04

OUTLINE

| 2

OUTLINE
•
•
•
•
•
•

Objective
Introduction
“&” Worksheet Function
“LEFT” Worksheet Function
“MID” Worksheet Function
“RIGHT” Worksheet Function

Cahaya Bangsa Classical School

Microsoft Office

(C) 2010 Digital Media Production Facility

13 – Microsoft Excel - 04

Objective

| 3

Understand Microsoft Excel
basic text manipulation formula with
“&”, “left”, “mid”, “right”
worksheet function

Cahaya Bangsa Classical School

Microsoft Office

(C) 2010 Digital Media Production Facility

13 – Microsoft Excel - 04

Introduction

| 4

Introduction
- Categorized as “Text” worksheet function
- Converts anything into text, including numbers
- However, arithmetic operation will transform any converted numbers
back to numbers.

Cahaya Bangsa Classical School

Microsoft Office

(C) 2010 Digital Media Production Facility

13 – Microsoft Excel - 04

“&” Worksheet Function

| 5

“&” Worksheet Function
- Purpose: to join cell content without special characters, including space
- Usages: as any other formula, always begin with “=“
follows by cell address
Example
A17 : cS4fG | C26 : 9f7ZKh
=A17&C26 will result cS4fG9f7ZKh

cell locking may applies
Cahaya Bangsa Classical School

Microsoft Office

(C) 2010 Digital Media Production Facility

13 – Microsoft Excel - 04

“LEFT” Worksheet Function

| 6

“LEFT” Worksheet Function
- Purpose: to grab cell content beginning from left to right
- Usages: as any other formula, always begin with “=“
=LEFT(cell address, #of characters)
Example
C16 : g4LkwS83
=LEFT(C16,3) will result : g4L

cell locking may applies
Cahaya Bangsa Classical School

Microsoft Office

(C) 2010 Digital Media Production Facility

13 – Microsoft Excel - 04

“MID” Worksheet Function

| 7

“MID” Worksheet Function
- Purpose: to grab cell content beginning from center to right
- Usages: as any other formula, always begin with “=“
=MID(cell address, start char #, #of characters)
Example
C16 : g4LkwS83
=MID(C16,3,2) will result : Lk
start from character #3 (k) then grab 2 characters (L and k)

cell locking may applies
Cahaya Bangsa Classical School

Microsoft Office

(C) 2010 Digital Media Production Facility

13 – Microsoft Excel - 04

“RIGHT” Worksheet Function

| 8

“RIGHT” Worksheet Function
- Purpose: to grab cell content beginning from right to left
- Usages: as any other formula, always begin with “=“
=RIGHT(cell address, #of characters)
Example
C16 : g4LkwS83
=RIGHT(C16,2) will result : 83 (as text, NOT number)

cell locking may applies
Cahaya Bangsa Classical School

Microsoft Office

(C) 2010 Digital Media Production Facility

13 – Microsoft Excel - 04

THANK YOU

| 9

THANK
YOU
Cahaya Bangsa Classical School

Microsoft Office

(C) 2010 Digital Media Production Facility


Slide 6

Microsoft Office
Grade 10 A / B

13

Microsoft Excel – 04
Cahaya Bangsa Classical School
(C) 2010 Digital Media Production Facility

13 – Microsoft Excel - 04

OUTLINE

| 2

OUTLINE
•
•
•
•
•
•

Objective
Introduction
“&” Worksheet Function
“LEFT” Worksheet Function
“MID” Worksheet Function
“RIGHT” Worksheet Function

Cahaya Bangsa Classical School

Microsoft Office

(C) 2010 Digital Media Production Facility

13 – Microsoft Excel - 04

Objective

| 3

Understand Microsoft Excel
basic text manipulation formula with
“&”, “left”, “mid”, “right”
worksheet function

Cahaya Bangsa Classical School

Microsoft Office

(C) 2010 Digital Media Production Facility

13 – Microsoft Excel - 04

Introduction

| 4

Introduction
- Categorized as “Text” worksheet function
- Converts anything into text, including numbers
- However, arithmetic operation will transform any converted numbers
back to numbers.

Cahaya Bangsa Classical School

Microsoft Office

(C) 2010 Digital Media Production Facility

13 – Microsoft Excel - 04

“&” Worksheet Function

| 5

“&” Worksheet Function
- Purpose: to join cell content without special characters, including space
- Usages: as any other formula, always begin with “=“
follows by cell address
Example
A17 : cS4fG | C26 : 9f7ZKh
=A17&C26 will result cS4fG9f7ZKh

cell locking may applies
Cahaya Bangsa Classical School

Microsoft Office

(C) 2010 Digital Media Production Facility

13 – Microsoft Excel - 04

“LEFT” Worksheet Function

| 6

“LEFT” Worksheet Function
- Purpose: to grab cell content beginning from left to right
- Usages: as any other formula, always begin with “=“
=LEFT(cell address, #of characters)
Example
C16 : g4LkwS83
=LEFT(C16,3) will result : g4L

cell locking may applies
Cahaya Bangsa Classical School

Microsoft Office

(C) 2010 Digital Media Production Facility

13 – Microsoft Excel - 04

“MID” Worksheet Function

| 7

“MID” Worksheet Function
- Purpose: to grab cell content beginning from center to right
- Usages: as any other formula, always begin with “=“
=MID(cell address, start char #, #of characters)
Example
C16 : g4LkwS83
=MID(C16,3,2) will result : Lk
start from character #3 (k) then grab 2 characters (L and k)

cell locking may applies
Cahaya Bangsa Classical School

Microsoft Office

(C) 2010 Digital Media Production Facility

13 – Microsoft Excel - 04

“RIGHT” Worksheet Function

| 8

“RIGHT” Worksheet Function
- Purpose: to grab cell content beginning from right to left
- Usages: as any other formula, always begin with “=“
=RIGHT(cell address, #of characters)
Example
C16 : g4LkwS83
=RIGHT(C16,2) will result : 83 (as text, NOT number)

cell locking may applies
Cahaya Bangsa Classical School

Microsoft Office

(C) 2010 Digital Media Production Facility

13 – Microsoft Excel - 04

THANK YOU

| 9

THANK
YOU
Cahaya Bangsa Classical School

Microsoft Office

(C) 2010 Digital Media Production Facility


Slide 7

Microsoft Office
Grade 10 A / B

13

Microsoft Excel – 04
Cahaya Bangsa Classical School
(C) 2010 Digital Media Production Facility

13 – Microsoft Excel - 04

OUTLINE

| 2

OUTLINE
•
•
•
•
•
•

Objective
Introduction
“&” Worksheet Function
“LEFT” Worksheet Function
“MID” Worksheet Function
“RIGHT” Worksheet Function

Cahaya Bangsa Classical School

Microsoft Office

(C) 2010 Digital Media Production Facility

13 – Microsoft Excel - 04

Objective

| 3

Understand Microsoft Excel
basic text manipulation formula with
“&”, “left”, “mid”, “right”
worksheet function

Cahaya Bangsa Classical School

Microsoft Office

(C) 2010 Digital Media Production Facility

13 – Microsoft Excel - 04

Introduction

| 4

Introduction
- Categorized as “Text” worksheet function
- Converts anything into text, including numbers
- However, arithmetic operation will transform any converted numbers
back to numbers.

Cahaya Bangsa Classical School

Microsoft Office

(C) 2010 Digital Media Production Facility

13 – Microsoft Excel - 04

“&” Worksheet Function

| 5

“&” Worksheet Function
- Purpose: to join cell content without special characters, including space
- Usages: as any other formula, always begin with “=“
follows by cell address
Example
A17 : cS4fG | C26 : 9f7ZKh
=A17&C26 will result cS4fG9f7ZKh

cell locking may applies
Cahaya Bangsa Classical School

Microsoft Office

(C) 2010 Digital Media Production Facility

13 – Microsoft Excel - 04

“LEFT” Worksheet Function

| 6

“LEFT” Worksheet Function
- Purpose: to grab cell content beginning from left to right
- Usages: as any other formula, always begin with “=“
=LEFT(cell address, #of characters)
Example
C16 : g4LkwS83
=LEFT(C16,3) will result : g4L

cell locking may applies
Cahaya Bangsa Classical School

Microsoft Office

(C) 2010 Digital Media Production Facility

13 – Microsoft Excel - 04

“MID” Worksheet Function

| 7

“MID” Worksheet Function
- Purpose: to grab cell content beginning from center to right
- Usages: as any other formula, always begin with “=“
=MID(cell address, start char #, #of characters)
Example
C16 : g4LkwS83
=MID(C16,3,2) will result : Lk
start from character #3 (k) then grab 2 characters (L and k)

cell locking may applies
Cahaya Bangsa Classical School

Microsoft Office

(C) 2010 Digital Media Production Facility

13 – Microsoft Excel - 04

“RIGHT” Worksheet Function

| 8

“RIGHT” Worksheet Function
- Purpose: to grab cell content beginning from right to left
- Usages: as any other formula, always begin with “=“
=RIGHT(cell address, #of characters)
Example
C16 : g4LkwS83
=RIGHT(C16,2) will result : 83 (as text, NOT number)

cell locking may applies
Cahaya Bangsa Classical School

Microsoft Office

(C) 2010 Digital Media Production Facility

13 – Microsoft Excel - 04

THANK YOU

| 9

THANK
YOU
Cahaya Bangsa Classical School

Microsoft Office

(C) 2010 Digital Media Production Facility


Slide 8

Microsoft Office
Grade 10 A / B

13

Microsoft Excel – 04
Cahaya Bangsa Classical School
(C) 2010 Digital Media Production Facility

13 – Microsoft Excel - 04

OUTLINE

| 2

OUTLINE
•
•
•
•
•
•

Objective
Introduction
“&” Worksheet Function
“LEFT” Worksheet Function
“MID” Worksheet Function
“RIGHT” Worksheet Function

Cahaya Bangsa Classical School

Microsoft Office

(C) 2010 Digital Media Production Facility

13 – Microsoft Excel - 04

Objective

| 3

Understand Microsoft Excel
basic text manipulation formula with
“&”, “left”, “mid”, “right”
worksheet function

Cahaya Bangsa Classical School

Microsoft Office

(C) 2010 Digital Media Production Facility

13 – Microsoft Excel - 04

Introduction

| 4

Introduction
- Categorized as “Text” worksheet function
- Converts anything into text, including numbers
- However, arithmetic operation will transform any converted numbers
back to numbers.

Cahaya Bangsa Classical School

Microsoft Office

(C) 2010 Digital Media Production Facility

13 – Microsoft Excel - 04

“&” Worksheet Function

| 5

“&” Worksheet Function
- Purpose: to join cell content without special characters, including space
- Usages: as any other formula, always begin with “=“
follows by cell address
Example
A17 : cS4fG | C26 : 9f7ZKh
=A17&C26 will result cS4fG9f7ZKh

cell locking may applies
Cahaya Bangsa Classical School

Microsoft Office

(C) 2010 Digital Media Production Facility

13 – Microsoft Excel - 04

“LEFT” Worksheet Function

| 6

“LEFT” Worksheet Function
- Purpose: to grab cell content beginning from left to right
- Usages: as any other formula, always begin with “=“
=LEFT(cell address, #of characters)
Example
C16 : g4LkwS83
=LEFT(C16,3) will result : g4L

cell locking may applies
Cahaya Bangsa Classical School

Microsoft Office

(C) 2010 Digital Media Production Facility

13 – Microsoft Excel - 04

“MID” Worksheet Function

| 7

“MID” Worksheet Function
- Purpose: to grab cell content beginning from center to right
- Usages: as any other formula, always begin with “=“
=MID(cell address, start char #, #of characters)
Example
C16 : g4LkwS83
=MID(C16,3,2) will result : Lk
start from character #3 (k) then grab 2 characters (L and k)

cell locking may applies
Cahaya Bangsa Classical School

Microsoft Office

(C) 2010 Digital Media Production Facility

13 – Microsoft Excel - 04

“RIGHT” Worksheet Function

| 8

“RIGHT” Worksheet Function
- Purpose: to grab cell content beginning from right to left
- Usages: as any other formula, always begin with “=“
=RIGHT(cell address, #of characters)
Example
C16 : g4LkwS83
=RIGHT(C16,2) will result : 83 (as text, NOT number)

cell locking may applies
Cahaya Bangsa Classical School

Microsoft Office

(C) 2010 Digital Media Production Facility

13 – Microsoft Excel - 04

THANK YOU

| 9

THANK
YOU
Cahaya Bangsa Classical School

Microsoft Office

(C) 2010 Digital Media Production Facility


Slide 9

Microsoft Office
Grade 10 A / B

13

Microsoft Excel – 04
Cahaya Bangsa Classical School
(C) 2010 Digital Media Production Facility

13 – Microsoft Excel - 04

OUTLINE

| 2

OUTLINE
•
•
•
•
•
•

Objective
Introduction
“&” Worksheet Function
“LEFT” Worksheet Function
“MID” Worksheet Function
“RIGHT” Worksheet Function

Cahaya Bangsa Classical School

Microsoft Office

(C) 2010 Digital Media Production Facility

13 – Microsoft Excel - 04

Objective

| 3

Understand Microsoft Excel
basic text manipulation formula with
“&”, “left”, “mid”, “right”
worksheet function

Cahaya Bangsa Classical School

Microsoft Office

(C) 2010 Digital Media Production Facility

13 – Microsoft Excel - 04

Introduction

| 4

Introduction
- Categorized as “Text” worksheet function
- Converts anything into text, including numbers
- However, arithmetic operation will transform any converted numbers
back to numbers.

Cahaya Bangsa Classical School

Microsoft Office

(C) 2010 Digital Media Production Facility

13 – Microsoft Excel - 04

“&” Worksheet Function

| 5

“&” Worksheet Function
- Purpose: to join cell content without special characters, including space
- Usages: as any other formula, always begin with “=“
follows by cell address
Example
A17 : cS4fG | C26 : 9f7ZKh
=A17&C26 will result cS4fG9f7ZKh

cell locking may applies
Cahaya Bangsa Classical School

Microsoft Office

(C) 2010 Digital Media Production Facility

13 – Microsoft Excel - 04

“LEFT” Worksheet Function

| 6

“LEFT” Worksheet Function
- Purpose: to grab cell content beginning from left to right
- Usages: as any other formula, always begin with “=“
=LEFT(cell address, #of characters)
Example
C16 : g4LkwS83
=LEFT(C16,3) will result : g4L

cell locking may applies
Cahaya Bangsa Classical School

Microsoft Office

(C) 2010 Digital Media Production Facility

13 – Microsoft Excel - 04

“MID” Worksheet Function

| 7

“MID” Worksheet Function
- Purpose: to grab cell content beginning from center to right
- Usages: as any other formula, always begin with “=“
=MID(cell address, start char #, #of characters)
Example
C16 : g4LkwS83
=MID(C16,3,2) will result : Lk
start from character #3 (k) then grab 2 characters (L and k)

cell locking may applies
Cahaya Bangsa Classical School

Microsoft Office

(C) 2010 Digital Media Production Facility

13 – Microsoft Excel - 04

“RIGHT” Worksheet Function

| 8

“RIGHT” Worksheet Function
- Purpose: to grab cell content beginning from right to left
- Usages: as any other formula, always begin with “=“
=RIGHT(cell address, #of characters)
Example
C16 : g4LkwS83
=RIGHT(C16,2) will result : 83 (as text, NOT number)

cell locking may applies
Cahaya Bangsa Classical School

Microsoft Office

(C) 2010 Digital Media Production Facility

13 – Microsoft Excel - 04

THANK YOU

| 9

THANK
YOU
Cahaya Bangsa Classical School

Microsoft Office

(C) 2010 Digital Media Production Facility