ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Number of Characters (https://www.excelbanter.com/excel-discussion-misc-queries/117676-number-characters.html)

Murray

Number of Characters
 
Hi all
Is there a method to remove excess charachters for a cell. I have a sheet I
receive from a work mate and the field length is not set, I want to go
through the cells and remove the excess characters.

Thanks

Gary''s Student

Number of Characters
 
Yes. How many do you want to remove??
--
Gary's Student


"Murray" wrote:

Hi all
Is there a method to remove excess charachters for a cell. I have a sheet I
receive from a work mate and the field length is not set, I want to go
through the cells and remove the excess characters.

Thanks


Murray

Number of Characters
 
I actually want to leave 24 and remove the rest

"Gary''s Student" wrote:

Yes. How many do you want to remove??
--
Gary's Student


"Murray" wrote:

Hi all
Is there a method to remove excess charachters for a cell. I have a sheet I
receive from a work mate and the field length is not set, I want to go
through the cells and remove the excess characters.

Thanks


Gary''s Student

Number of Characters
 
Let's say your data is in column A.

In B1 enter:
=LEFT(A1,24)
and copy this down the column

Column B will contain the data in column A reduced to the first 24 characters

--
Gary's Student


"Murray" wrote:

I actually want to leave 24 and remove the rest

"Gary''s Student" wrote:

Yes. How many do you want to remove??
--
Gary's Student


"Murray" wrote:

Hi all
Is there a method to remove excess charachters for a cell. I have a sheet I
receive from a work mate and the field length is not set, I want to go
through the cells and remove the excess characters.

Thanks



All times are GMT +1. The time now is 07:25 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com