Removing the first character in a row *only if it's a number (Google Sheets / Excel)

Question

I have data structured like so:

example1testtest3450moreexamples61

My question is; what formula should I use to delete the first character *only if it's a number (the numbers at the end ar fine). Thus:

1test > test0moreexamples61 > moreexamples61

Regards!

Accepted Answer

You can use the following formula, which will work both in Google Sheets and in Excel:

=IF(ISNUMBER(VALUE(LEFT(A1,1))),RIGHT(A1,LEN(A1)-1),A1)

The ISNUMBER(VALUE(LEFT(A1,1))) term will check if the first letter. If it is a number, it will evaluate to True.

If it is True, the term RIGHT(A1,LEN(A1)-1) will take all text except the first letter and return it in the cell.

Remove first character if it is a number in Gogole sheets or Excel