How to have charac in new column with 40 char length only...
in [General]
|
Prev: Upper Case Letters to First Letter Upper, Remaining Letters Lo
Next: EXCEL-2000 column headings hide from data
From: Rajat on 24 Feb 2010 11:34 I have a below requirement: In one column i am having some words of different-different length, e.g some 70 charac., some 60,50,100,90 etc. but i want to have all of them copy to new column but with length only 40 charc....rest of the charac i don't want.... plz help. Thanks in advance Rajat
From: Luke M on 24 Feb 2010 11:38 =LEFT(A2,40) Copy down as needed -- Best Regards, Luke M "Rajat" <Rajat(a)discussions.microsoft.com> wrote in message news:86F5DCBB-99CB-4E04-8903-BA4D15597C7D(a)microsoft.com... >I have a below requirement: > In one column i am having some words of different-different length, e.g > some > 70 charac., some 60,50,100,90 etc. > > but i want to have all of them copy to new column but with length only 40 > charc....rest of the charac i don't want.... > plz help. > > Thanks > in advance > Rajat
From: מיכאל (מיקי) אבידן on 24 Feb 2010 11:43
Check out Excels LEFT Function. Micky "Rajat" wrote: > I have a below requirement: > In one column i am having some words of different-different length, e.g some > 70 charac., some 60,50,100,90 etc. > > but i want to have all of them copy to new column but with length only 40 > charc....rest of the charac i don't want.... > plz help. > > Thanks > in advance > Rajat |