Excel CHAR Function with Two Examples

preview_player
Показать описание

The CHAR function of Excel may not seem too useful at first glance, but it can be very handy at cleansing and presenting text data.

In this video tutorial, we look at two examples of how this function can be useful to you.

Find more great free tutorials at;

*** Online Excel Courses ***

Connect with us!
  1. Computergaga
  2. Microsoft Excel
  3. CHAR Function
  4. CHAR formula
  5. Excel Formulas
  6. Excel Text Functions
Рекомендации по теме
Excel CHAR Function 0:08:49

Excel CHAR Function with Two Examples

Excel TEXTJOIN, CONCATENTATE 0:06:27

Excel TEXTJOIN, CONCATENTATE and CHAR Functions to Join Text

#195-How to use 0:15:07

#195-How to use CHAR Function in Excel with 4 Examples

Char Formula in 0:02:50

Char Formula in Excel

TEXTJOIN with Multiple 0:01:35

TEXTJOIN with Multiple Different Delimiters at Once in Excel - Excel Quickie 75

Unlock Special Characters 0:00:10

Unlock Special Characters with the CHAR Function in Excel #char #spreadsheetskills #dataanalysis

Extract Text Between 0:06:30

Extract Text Between Two Characters in Excel

Discover the magic 0:07:31

Discover the magic of the CHAR function in Excel - Concatenation, Carriage Returns and more ....

Find and Search 0:07:10

Find and Search Functions | Difference Between Find and Search in Excel Explained in Hindi

Very Useful Function 0:05:35

Very Useful Function Code And Char Function In Excel

Excel Tricks - 0:03:17

Excel Tricks - How To Concatenate With A Line Break In Excel

How to Extract 0:03:27

How to Extract Characters from a Cell in Excel

Index Match with 0:07:45

Index Match with Multiple Criteria

How to insert 0:03:39

How to insert special character at every cell in Excel

Using the One 0:06:53

Using the One Character Excel Functions (T Function | N Function)

Using Excel VLOOKUP 0:08:12

Using Excel VLOOKUP Function with Multiple Criteria (Multiple Cells)

Excel - COUNTIFS 0:05:23

Excel - COUNTIFS with multiple criteria and OR logic

The Learnit Minute 0:00:54

The Learnit Minute - CHAR Function #Excel #Shorts

How to Add 0:03:44

How to Add MULTIPLE Sets of Data to ONE GRAPH in Excel

TEXTSPLIT Function in 0:00:26

TEXTSPLIT Function in Excel #shorts

Sumifs formula in 0:00:18

Sumifs formula in excel | Excel formula #shorts #sumifs

Excel If formula 0:02:15

Excel If formula - If CONTAINS formula in Excel - 2 Minute Excel Formula

Extract Last Name 0:00:38

Extract Last Name using TEXTAFTER function in Excel

Excel: IF Function 0:10:01

Excel: IF Function MULTIPLE CRITERIA | IF ELSE Function | Nested IF Function

Комментарии
Автор

Great.. Thanks for a examples number two solutions 👍👍👍

andrinuka
Автор

HI, on your first example, I would like to put the comma on each cells, For example, 10 Kings Hill, Colchester, Essex, CO9 7TH.
A2&", ", But it does not work. Excel has an error message even I put the first past ", ", .
Do you have any idea how to hand it? Or I have to use Textjoin first. Thanks.

cindyc
Автор

Wow Alan, a very useful video, thank you very much.
Cheers
Mohideen

mohideenthassim
Автор

what is the difference between char(10) and char(12), sir?
is there any other char number?
Can you tell me how can i find out information about other char numbers and an explanation of those other char numbers?

Apel
Автор

Hi is it possible to put formula only first line of the cell?
For example
1. Balance as on 30-9-23
2.

First line i want to Formulalise in order to change the date automatically in every month.

biswadeepsarkar
Автор

This is great! I do have a question, what if you have a blank cell? For Example B2 has nothing on it, then you will have a blank space? is there a way to get rid of the space then? Thank you very much this is very useful.

christiannepogie
Автор

Hi, how do you find the Char codes . thank you

kevintsang
Автор

as far as i know we can enter maximum 16 digit number in a cell...
how can i input more digits

chinmayeesingh