Excel Trick: Extract INITIALS from NAME LIST

preview_player
Показать описание
Want more productivity videos like this? Like and Subscribe to the channel!

Excel Trick: Extract INITIALS from NAME LIST

FORMULA: =LEFT(A2)&IF(ISNUMBER(FIND(" ",A2)),MID(A2,FIND(" ",A2)+1,1),"")&IF(ISNUMBER(FIND(" ",A2,FIND(" ",A2)+1)),MID(A2,FIND(" ",A2,FIND(" ",A2)+1)+1,1),"")

#shorts #exceltricks #microsoftexcel #shortsshelf #shortsfeed #youtubeshorts #exceltips #exceltutorial #excel #microsoftexceltips #excelshortsvideo #excelformula #googlesheets #howto #ytshorts
  1. ProDOCTORtivity
  2. excel tips
  3. get the initials from a list of names in excel
  4. microsoft excel
  5. shorts
  6. shorts shelf
Рекомендации по теме
Excel Pro Trick: 0:00:39

Excel Pro Trick: Extract Initials from Names in Excel using Flash Fill Shortcut: No Formula Approach

Extract Initials From 0:00:22

Extract Initials From Names In Excel - MS Excel

Excel pro trick.Extract 0:00:59

Excel pro trick.Extract initials from name in excel using Flash fill . Shortcut No formula approach

How to get 0:00:43

How to get Initials in excel #shorts

Extract first character 0:00:12

Extract first character in excel | Use of left Function | Extract initials from name

Excel Tricks How 0:00:46

Excel Tricks How To Get Initial From Name in Excel Fast Without Formula

Extract Initials from 0:00:35

Extract Initials from Names in Excel using Flash #excel

Extract the Initials 0:01:09

Extract the Initials from a list of names in excel by Pavan Lalwani | shorts #shorts #exceltips

How to Extract 0:01:42

How to Extract Initials From a Name in Excel | Excel Malayalam |

Extract Names & 0:00:57

Extract Names & Initials From Email Ids in Excel using this Trick - Shiva Charan #excelshorts

Extract First Name 0:00:36

Extract First Name using TEXTBEFORE function in Excel

Extracting Initials from 0:00:59

Extracting Initials from Names in Excel | Tutor Joes

How to get 0:00:19

How to get initials from name in excel? l excel formula hacks l excel tutoring

Use Excel and 0:09:34

Use Excel and Text Functions to Extract the Middle Initial from Names

How To Extract 0:00:36

How To Extract Last Name || Right Formula || Excel Formulas

How to Remove 0:02:33

How to Remove Middle Initials from Full Name in Excel

How to get 0:00:11

How to get initials for all names in Excel! #excel

How to Remove 0:04:42

How to Remove Initials from Name in Excel

Remove Initials from 0:00:32

Remove Initials from Full Name using TextSplit and TextJoin in Excel #exceltricks #exceltips

Excel Shortcut 31 0:00:37

Excel Shortcut 31 - Extracting First Name, Last Name and Initial

Get first word 0:02:32

Get first word or get LEFT word in Excel - 2 Minute Excel Formula

Extract initial from 0:01:01

Extract initial from full name in MS Excel #excelformula

How to get 0:00:11

How to get the first letter of a name in Excel! #excel

Extract Last Name 0:00:38

Extract Last Name using TEXTAFTER function in Excel

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

Formula to paste =LEFT(A2)&IF(ISNUMBER(FIND(" ", A2)), MID(A2, FIND(" ", A2)+1, 1), "")&IF(ISNUMBER(FIND(" ", A2, FIND(" ", A2)+1)), MID(A2, FIND(" ", A2, FIND(" ", A2)+1)+1, 1), "")

ProDOCTORtivity