TEXT Function in Excel | Formula | Use of TEXT Function in Excel
In this video, we are going to learn how to use Text function in excel using Text Formula.
𝐓𝐞𝐱𝐭 𝐅𝐮𝐧𝐜𝐭𝐢𝐨𝐧 𝐢𝐧 𝐄𝐱𝐜𝐞𝐥
-------------------------------------------
The text function in excel coverts the numerical values into a text format stated.
𝐓𝐞𝐱𝐭 𝐄𝐱𝐜𝐞𝐥 𝐅𝐨𝐫𝐦𝐮𝐥𝐚
---------------------------------------
Below is the formula of Text Function
= TEXT (value, format_text)
𝐀𝐫𝐠𝐮𝐦𝐞𝐧𝐭𝐬
----------------------------
Value = Value to be formatted.
format_text = Format code we would like to apply.
𝐓𝐞𝐱𝐭 𝐅𝐮𝐧𝐜𝐭𝐢𝐨𝐧 𝐅𝐨𝐫𝐦𝐚𝐭 𝐂𝐨𝐝𝐞 𝐃𝐮𝐫𝐢𝐧𝐠 𝐃𝐚𝐭𝐞 𝐇𝐚𝐧𝐝𝐥𝐢𝐧𝐠
-----------------------------------------------------------------------------------------
Format Code Description Using Text Function Output
d It shows the day 12 12
as a number without
a leading zero.
m It shows the month 1 1
as a number without
a leading zero.
yy It shows the year 18 or 2018 18 or 2018
as a 2 digit no(00-99)
or 4 digit number(1990-9999)
To know more about 𝐓𝐞𝐱𝐭 𝐄𝐱𝐜𝐞𝐥 𝐅𝐮𝐧𝐜𝐭𝐢𝐨𝐧, you can go to this 𝐥𝐢𝐧𝐤 𝐡𝐞𝐫𝐞:- https://www.wallstreetmojo.com/text-f...
Subscribe to our channel to get new updated videos. Click the button above to subscribe or click on the link below to subscribe - / @wallstreetmojo
