amit arun associates
   
Home Contact Us Site Map
Home about us Latest News Contact us

Fixed Assets Verification Services

Payroll Processing Service

Employee Benefit Administration

Tax Consulting

Foreign Direct Investment

File GST & E-TDS Returns
 
 
 
 
 

Excel Commands

Posted @ July 28, 2019, 1:13 am under (ICAI & Accounting)

The LEN function gets the total number of characters in a string, When subtract the number of unwanted characters from the total length, and have the LEFT function return the remaining characters.

=LEFT(A2,LEN(A2)-12)

=RIGHT(A2,LEN(A2)-12)


Website Designing  Company Image Map
Contact us Disclaimer Privacy Policy Site Map