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

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
 
Top