The REPLACE function
The easiest way to remove the first character from a cell is to use the REPLACE function.
This function replaces a part of a string with a different string.
=REPLACE( old_text, start_num, num_chars, new_text )
old_text – The function takes “!This is text” as the first argument.
start_num – Which character to replace. In our case, it’s the first one.
num_chars – The number of characters to replace. We want only 1.
new_text – The text to replace the portion of the text. In our case is empty space, because we want the first character to be deleted.
RIGHT and LEN functions
The RIGHT function returns the number of characters from the right of the string.
The LEN function returns the length of the string.
The following formula will return all characters – 1 from the RIGHT.
Let’s check it inside the worksheet.
You can use this simple function to remove the first character from a string. It will take one argument, which is a string.
Function RemoveFirstCharacter(rng As String) RemoveFirstCharacter = Right(rng, Len(rng) - 1) End Function
Insert this function into a new module and use it as a normal function.