How to remove left character in strings of unequal length
Use MID and start with the 2nd character:
=MID(A1,2,LEN(A1))
You can use SUBSTITUTE() to remove $ character, like this:
=VALUE(SUBSTITUTE(A2,"$",""))
How to remove left character in strings of unequal length
Use MID and start with the 2nd character:
=MID(A1,2,LEN(A1))
You can use SUBSTITUTE() to remove $ character, like this:
=VALUE(SUBSTITUTE(A2,"$",""))