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

=LEFT(A2,40)

Copy down as needed

--
Best Regards,

Luke M
"Rajat" wrote in message
...
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

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