How to have charac in new column with 40 char length only...

  • Thread starter Thread starter Rajat
  • Start date Start date
R

Rajat

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
 
Back
Top