Remove Firt or last N character

1.1 Remove first N characters with RIGHT / REPLACE function

>> Combine RIGHT and LEN function to remove first N characters

Formula syntax and arguments

Formula:    =RIGHT(string_cell,LEN(string_cell)-n_character)

Reference: string_cell: the cell you use to remove characters

n_character: the number of characters you want to remove

Example: Remove first 2 characters from string in Cell A2, copy and paste the formula
=RIGHT(A2,LEN(A2)-2)
press Enter key
doc remove first last 2

SOURCE
https://www.extendoffice.com/documents/excel/3329-excel-remove-first-last-n-characters.html

Advertisements
This entry was posted in Compus, General, Tech. Bookmark the permalink.