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

You could Paste the first sheet to the second sheet then convert text to
columns and choose a fixed width.

or

or in cell a1 use the left(Sheet1!a1, 4) function
in cell b1 use mid(sheet1!b1,a1,5,255) function

then copy both formulas down

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=519336

In WS2, A1 enter:
=LEFT(Sheet1!A1,4)
In B1 enter:
=MID(Sheet1!A1,5,256)


"nick" wrote:

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

Thank You

"Dav" wrote:


You could Paste the first sheet to the second sheet then convert text to
columns and choose a fixed width.

or

or in cell a1 use the left(Sheet1!a1, 4) function
in cell b1 use mid(sheet1!b1,a1,5,255) function

then copy both formulas down

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=519336

Thank You

"Jim May" wrote:

In WS2, A1 enter:
=LEFT(Sheet1!A1,4)
In B1 enter:
=MID(Sheet1!A1,5,256)


"nick" wrote:

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