VID.6: How to Generate a Unique ID in Google Sheets (with Acronym)
Вставка
- Опубліковано 3 жов 2024
- #Google_sheets #googlesheets #css #html
#html #css #javascript #tutorials #trending #new #google #googlesheets #integration
#HTMLForms #DataEntryMagic #appsscript #htmlform #htmlforms #automation
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.
/ @safdardasti
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))
------------------------------------------------------------------------------------------------
SOURCE:
docs.google.co...
LinkedIn Link: / all
ٖFacebook Link: / tibbaimam.taunsa.9
• Vid.1: Create Id base ...
• VID.2: STUDENT FEE MAN...
• VID.3: Files upload,Vi...
• VID.4: How To Send HTM...
• VID.5: Html Form Data ...
• VID.6: How to Generate...
• Vid.7: Google Sheets |...
• VID.8: Google Sheet + ...
• Vid. 9: Google Sheets ...