filmov
tv
Extract the Initials from a list of names in excel by Pavan Lalwani | shorts #shorts #exceltips
Показать описание
Extract the Initials from a list of names in excel by Pavan Lalwani | shorts #shorts #exceltips
Excel tips and tricks.
(welcome back in this video we'll see how to find out the first letter last letter or the initials of a data let us see an example if you see on the left hand side I have list of name and I want to find out the first alphabet of their names. i
If I want the first alphabet so I'll type as a enter control E from my keyboard and you can see first letter of every name has been displayed. Same way if I want the first alphabet of the last name I'll just type as R enter and control e and you can see first alphabet of the last name is given.
Now if I want to find out the initials of their name for example if it is A**** I want a r A**** a b so I'll type as a space r enter control e control is a shortcut to find out the pattern of your data and you see A*** B*** the initials are given as a b.
So without using keyboard without using any functions you can get the answers using Flash Fill that is controlling I hope you have understood that's all for this video)
#businessintelligence, business intelligence, #pavanlalwani
Welcome to the world of data analysis and business intelligence! Whether you're a data analyst looking to sharpen your skills or a business professional looking to expand your knowledge, our online course led by Pavan Lalwani is the perfect choice. Learn everything from the basics of data analytics to advanced business intelligence techniques and take your career to the next level. Join our business intelligence online course and become a data analyst or a business intelligence analyst. Learn the latest trends and best practices of data analytics, business intelligence and data visualization on youtube with Pavan Lalwani, an expert in the field. Get ready to transform your data into actionable insights and make informed business decisions with our comprehensive business intelligence course.
Excel tips and tricks.
(welcome back in this video we'll see how to find out the first letter last letter or the initials of a data let us see an example if you see on the left hand side I have list of name and I want to find out the first alphabet of their names. i
If I want the first alphabet so I'll type as a enter control E from my keyboard and you can see first letter of every name has been displayed. Same way if I want the first alphabet of the last name I'll just type as R enter and control e and you can see first alphabet of the last name is given.
Now if I want to find out the initials of their name for example if it is A**** I want a r A**** a b so I'll type as a space r enter control e control is a shortcut to find out the pattern of your data and you see A*** B*** the initials are given as a b.
So without using keyboard without using any functions you can get the answers using Flash Fill that is controlling I hope you have understood that's all for this video)
#businessintelligence, business intelligence, #pavanlalwani
Welcome to the world of data analysis and business intelligence! Whether you're a data analyst looking to sharpen your skills or a business professional looking to expand your knowledge, our online course led by Pavan Lalwani is the perfect choice. Learn everything from the basics of data analytics to advanced business intelligence techniques and take your career to the next level. Join our business intelligence online course and become a data analyst or a business intelligence analyst. Learn the latest trends and best practices of data analytics, business intelligence and data visualization on youtube with Pavan Lalwani, an expert in the field. Get ready to transform your data into actionable insights and make informed business decisions with our comprehensive business intelligence course.
0:00:22
Extract Initials From Names In Excel - MS Excel
0:03:16
How to: Extract initials from a cell
0:01:00
Easy Way To Extract Initials From Names 😮 #shorts
0:01:09
Extract the Initials from a list of names in excel by Pavan Lalwani | shorts #shorts #exceltips
0:00:12
Excel Trick: Extract INITIALS from NAME LIST
0:00:12
Extract first character in excel | Use of left Function | Extract initials from name
0:00:17
extract initials from name
0:01:40
How To Easily Get Initials From Names In Google Sheets
0:00:39
Excel Pro Trick: Extract Initials from Names in Excel using Flash Fill Shortcut: No Formula Approach
0:00:16
Extract Initials From Name
0:00:59
ExcelShort83 Extract Initials From Names In Excel
0:01:15
How to extract initials from names in Excel? 2 Ways!!!
0:00:57
SDU Tools 128 Extract Initials from a Name in SQL Server T SQL
0:03:59
Tricky SQL Interview Question: Get Initials From a Name. #datascience #mssql #programming #database
0:00:35
Extract Initials from Names in Excel using Flash #excel
0:00:42
How to Get Initials in Excel? 💪 #shorts
0:00:43
How to get Initials in excel #shorts
0:02:44
Program to find the initials of a name | GeeksforGeeks
0:00:14
The Fastest Way to Get Initials In Excel ✔️#shorts
0:00:35
How to Extract First, Middle, Last, and Initials from Full Name #excel #learnexcel #exceltutorial
0:01:42
How to Extract Initials From a Name in Excel | Excel Malayalam |
0:00:46
Javascript program get initials from a name
0:04:10
Get Initials From a List of Names in Excel
0:01:00
JavaScript Program to get initials from a name | JavaScript Interview Questions
Комментарии