79224924

Date: 2024-11-26 00:11:03
Score: 1
Natty:
Report link

=REPLACE(A1,1,n,"") - where n is the number of chars you want to remove, by @barry houdini is the most elegant method.

You can use MID(string,start,nn) - where nn is larger than the longest string and it will just use the remaining chars, or

MID(string,start,LEN(string) - which grabs the total length of the original string if you want to make sure.

Reasons:
  • Whitelisted phrase (-1.5): You can use
  • No code block (0.5):
  • User mentioned (1): @barry
  • Low reputation (1):
Posted by: Gary Wheatcroft