KEMBAR78
Text Functions | PDF
Scribd
Upload
4 views10 pages

Text Functions

The document provides various methods for concatenating names and manipulating text in Excel, including functions like CONCAT, TEXTJOIN, and SUBSTITUTE. It also includes examples of statistical functions such as Mean, Median, and Standard Deviation. Additionally, it highlights the differences between certain text functions and their capabilities.

Uploaded by

garvit0134
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
4 views10 pages

Text Functions

The document provides various methods for concatenating names and manipulating text in Excel, including functions like CONCAT, TEXTJOIN, and SUBSTITUTE. It also includes examples of statistical functions such as Mean, Median, and Standard Deviation. Additionally, it highlights the differences between certain text functions and their capabilities.

Uploaded by

garvit0134
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 10

First Middle Last Full Name Full Name

Name Name Name (CONCAT) (CONCATENATE) Full Name (&)


John Khwasa Doe
Jane Smith
Mike Kr. Brown
Emily M Davis

Full Name
First Middle Last (TEXTJOIN) - Full Name
Name Name Name True (TEXTJOIN) - False
John Khwasa Doe John Khwasa Doe
Jane Smith Jane Smith
Mike Kr. Brown Mike Kr. Brown
Emily M Davis Emily M Davis
Concatenate Does not support ranges like A1:A3 directly
Concat Supports ranges and arrays like A1:A3 directly

Type 1 =CONCAT(A2, " ", B2," ", C2)


Type 2 =A2 & " " & B2& " " & C2
Type 3 =TEXTJOIN(" ", TRUE, A2, B2,C2)
Original Text LOWER UPPER PROPER TRIM
heLLo WoRLd
eXceL FunCTions
Data ANALYSIS
openAI GPT
Text LEFT(5) RIGHT(5)
ExcelFunctions
TextProcessing
DataScience
Visualization
MID(3,4) LEN
Replace
GL Bajaj is our college =REPLACE(A3,3,2,"my")

Substitute
GL Bajaj is our our college =SUBSTITUTE(A6,"our","my",2)
GL Bajaj is our OUR college =SUBSTITUTE(A7,"our","my",2)
Text1 Text2 EXACT
Excel excel
Data Data
Trim trim
hello HELLO
REPT("*", 5) REPT("-", LEN(Text1))
Sample Statistical
Data Functions
58 Mean
18 Median
37 Mode
44 Mode.Mult
45
50
68 Standard Deviation(P)
73 Standard Deviation(S)
73 Frequency Function
73 Histogram
81
87
87
87
88
93
95
95
95
99

You might also like