R
reena
I want to write a macro for copying first number of letters of a value
of the cell.
for eg.
My column contains values as
abcdefghijklmnop
xyzsgfht
reenap
pppppppppppp
Now here I want to select only "abcd" - first 4 characters of the
entire column and copy it in other excel sheet. New sheet should
contain
abcd
xyzs
reen
pppp
as column.
How can I do that?
of the cell.
for eg.
My column contains values as
abcdefghijklmnop
xyzsgfht
reenap
pppppppppppp
Now here I want to select only "abcd" - first 4 characters of the
entire column and copy it in other excel sheet. New sheet should
contain
abcd
xyzs
reen
pppp
as column.
How can I do that?