How to remove extra characters from a cell?

A

Andrey Bondarchuk2015-07-07 15:04:03

excel

Andrey Bondarchuk, 2015-07-07 15:04:03

The cells have words of different lengths, is there a function or macro that would allow you to remove extra characters from the cell so that the length of the words is, for example, 7 characters?

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

V

Vov Vov, 2015-07-07
@sh1kima26

=LEFT(TEXT,NUMBER OF CHARACTERS LEFT)