Extragerea de cuvinte sau caractere dintro celula Excel
>> YOUR LINK HERE: ___ http://youtube.com/watch?v=lAh9AoWgCug
Functii utile in Excel pentru extragerea unui cuvant sau caractere dintr-o celula. • Functii folosite in prezentare LEFT, RIGHT, SEARCH, LEN, CONCATENATE. • Modelarea bazelor de date cu usurinta • =LEFT(A1,3) • =RIGHT(F1,3) • =LEFT(A1,SEARCH( ,A1)) • =RIGHT(A1,LEN(A1)-SEARCH( ,A1)) • =CONCATENATE(B1 C1) • #Microsoft Office #Excel #Formulas #IT Learning #Tutorial #Training
#############################
