Hello

I'm trying to limit the characters in column A to 7 for example:

12345678901242 will become 1234567 or Abcdefghijk will become Abcdefg

I'd rather not use the =LEFT() function or validation because I'm importing the values from a text file and the user will be able to enter their values

Can anyone help with a loop or function for this?

Thanks in advance