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)

Similar questions

C

CyberW2015-10-31 20:12:50

Is it possible to upload an MS Excel file to Google Drive via the API and share it in Google Spreadsheets? 0Reply

V

VallCC2021-07-12 09:42:24

How to display a range of values from one sheet to another with a condition? 2Reply

A

Arthur Koch2012-02-02 11:34:40

Convert pdf, xls, doc documents to HTML 2Reply

L

la02012-02-03 19:47:48

Excel 2007: Warnings about closing unsaved documents suddenly stopped appearing 2Reply

A

Aristokrat- govno na rukave2018-03-21 17:24:07

Why is it not looking for text on the page? 2Reply

Didn't find what you were looking for?

Ask your question