software

Hi,
I am preparing a template where i want the rule to be as follows:
Ex: quot;abcdefghiquot; 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 quot;abcdquot; and the
remaining characters quot;efghiquot; 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: www.excelforum.com/member.php...oamp;userid=27107
View this thread: www.excelforum.com/showthread...hreadid=519336In WS2, A1 enter:
=LEFT(Sheet1!A1,4)
In B1 enter:
=MID(Sheet1!A1,5,256)quot;nickquot; wrote:

gt; Hi,
gt; I am preparing a template where i want the rule to be as follows:
gt; Ex: quot;abcdefghiquot; is the name in worksheet1 and i wanna import that data in
gt; worksheet2 with a fixed character lenth in multiple cells.
gt;
gt; A1 in worksheet 2 should be first 4 characters thats quot;abcdquot; and the
gt; remaining characters quot;efghiquot; should go to B1 of worksheet 2. How do i do
gt; this? I hope i framed my Q rite. Any help wld be appreciated. thanks

Thank You

quot;Davquot; wrote:

gt;
gt; You could Paste the first sheet to the second sheet then convert text to
gt; columns and choose a fixed width.
gt;
gt; or
gt;
gt; or in cell a1 use the left(Sheet1!a1, 4) function
gt; in cell b1 use mid(sheet1!b1,a1,5,255) function
gt;
gt; then copy both formulas down
gt;
gt; Regards
gt;
gt; Dav
gt;
gt;
gt; --
gt; Dav
gt; ------------------------------------------------------------------------
gt; Dav's Profile: www.excelforum.com/member.php...oamp;userid=27107
gt; View this thread: www.excelforum.com/showthread...hreadid=519336
gt;
gt;

Thank You

quot;Jim Mayquot; wrote:

gt; In WS2, A1 enter:
gt; =LEFT(Sheet1!A1,4)
gt; In B1 enter:
gt; =MID(Sheet1!A1,5,256)
gt;
gt;
gt; quot;nickquot; wrote:
gt;
gt; gt; Hi,
gt; gt; I am preparing a template where i want the rule to be as follows:
gt; gt; Ex: quot;abcdefghiquot; is the name in worksheet1 and i wanna import that data in
gt; gt; worksheet2 with a fixed character lenth in multiple cells.
gt; gt;
gt; gt; A1 in worksheet 2 should be first 4 characters thats quot;abcdquot; and the
gt; gt; remaining characters quot;efghiquot; should go to B1 of worksheet 2. How do i do
gt; gt; this? I hope i framed my Q rite. Any help wld be appreciated. thanks