Generate Unique IDs in Google Sheets LIKE A PRO! (Acronym)
#Google_sheets
In this tutorial, I will show you how to create a formula for generating a unique ID that contains acronyms.
In this video, you learn to create an ID that is unique for your data and extract useful info from that.
Formula👇
=TEXTJOIN("-",True,IF(LEN(B2)-LEN(SUBSTITUTE(B2," ",""))=0,LEFT(B2,1),IF(LEN(B2)-LEN(SUBSTITUTE(B2," ",""))=1,LEFT(B2,1)&MID(B2,FIND(" ",B2)+1,1),LEFT(B2,1)&MID(B2,FIND(" ",B2)+1,1)&MID(B2,FIND(" ",B2,FIND(" ",B2)+1)+1,1))),LEFT(C2,3),RIGHT(D2,2),LEFT(E2,3))
------------------------------------------------------------------------------------------------
Timestamps
00:00 Intro
06:28 Generate Formula
04:50 Acronym Formula
05:25 Test the formula
06:06 Wrap up
------------------------------------------------------------------------------------
❤️ Help me pay for my first Camera❤️
https://www.paypal.com/paypalme/elahe...
------------------------------------------------------------------------------------
❤️ Link to the Website❤️
https://sheetfacts.com/
---------------------------------------------------------------------------------------------------------
Subscribe link
/ @techtrickswitheli2023
-------------------------------------------------------------------------------
Related Links and useful playlists
Google sheets playlist
• Google Sheets Tutorials
Google Forms playlist
• Google Form Tutorial