Hi,
I am preparing a template where i want the rule to be as follows:
Ex: "abcdefghi" is the name in worksheet1 and i wanna import that data in
worksheet2 with a fixed character lenth in multiple cells.

A1 in worksheet 2 should be first 4 characters thats "abcd" and the
remaining characters "efghi" should go to B1 of worksheet 2. How do i do
this? I hope i framed my Q rite. Any help wld be appreciated. thanks