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
press Enter key
doc remove first last 2


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