Posts

Showing posts from January, 2024

Remove last two character from a cell value in excel

 =LEFT(C2,LEN(C2)-2) Remove First two Character From a cell value =RIGHT(C2,LEN(C2)-2)

convert text to number in excel

Image
 =VALUE(TRIM(CLEAN(E2)))