How to remove extra characters from a cell?

A

A

Andrey Bondarchuk2015-07-07 15:04:03

excel

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

How to remove extra characters from a cell?

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

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)

Similar questions

I

Irina2019-03-02 00:26:56

Why doesn't heroku see the pywin32 library when deploying? 1Reply

V

vitya_brodov2022-04-22 06:08:59

How to parse an excel curve in java? 1Reply

T

Toster2342019-03-06 09:50:37

How to change an Excel macro from "vertical" to "horizontal"? 1Reply

P

partyzanx2019-03-08 17:33:55

How to make all the songs from two columns into one in excel? 1Reply

W

Worlding2016-10-09 13:39:08

How to transfer contacts from excel to google? 3Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question