Learn Excel- Important Excel tips

Important Text Formulas in Excel
Please find some important tips in Excel that may be very useful in Accounts, Finance and Audit.

Data Result Formula
Ali AliAsjad =CONCATENATE(A3,A4)
Asjad

Ali Asjad Ali Asjad =TRIM(A6)

Ali Asjad ALI ASJAD =UPPER(A8)

Ali Asjad ali asjad =LOWER(A10)

ali asjad Ali Asjad =PROPER(A12)

01-01-03-000015 Fixed Asset 01-01-03-000015 =LEFT(A14,15)

01-01-03-000015 Fixed Asset Asset =RIGHT(A16,5)

01-01-03-000015 Fixed Asset Fixed Asset =MID(A18,17,20)

ali
ALI FALSE =EXACT(A20,A21)

I IIIIIIIIIIIIIII =REPT(A23,15)