software

I have this dilemma. I have a number in column B of spreadsheet one. I need
to split that number and put the first 8 digits into column D of another
spreadsheet.

Here's what it looks like.

Spreadsheet one, Column B: 12345678_987654321

I need to put into spreadsheet two, Column D: 12345678 from spreadsheet one.

Spreadsheet one, Column D has number 987654321. I need to use this as an
anchor to put the right numbers from spreadsheet one, column B into
spreadsheet two, column D.

THANK YOU!!!


If I have understood correctly...

in sheet2 D2 use this formula copied down column

=LEFT(INDEX(Sheet1!B:B,MATCH(quot;*quot;amp;Sheet1!D2,Sheet1! B:B,0)),8)--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=508284are you familiar with vlookup?,=left(vlookup(customer
id,sheet1!table_array,2,false),8)
--
paul
remove nospam for email addy!
quot;Paperback Writerquot; wrote:

gt; That won't anchor me, will it?
gt;
gt; Let me explain better.
gt;
gt;
gt; Sheet 1.
gt;
gt; Column B Column C
gt; NUM NAME
gt; 987654321 12345678 987654321
gt;
gt;
gt; Sheet 2.
gt;
gt; Column E Column D
gt; ID SEC NUM
gt; 987654321 (I need this to say) 12345678
gt;
gt; From S2, column E can hook into S1, column B. I need the first 8 characters
gt; of S1, column C to go into S2, column D.
gt;
gt;
gt;
gt; quot;paulquot; wrote:
gt;
gt; gt; say in d2 of sheet2 =LEFT(sheet1!B2,8)
gt; gt;
gt; gt; --
gt; gt; paul
gt; gt; remove nospam for email addy!
gt; gt;
gt; gt;
gt; gt; quot;Paperback Writerquot; wrote:
gt; gt;
gt; gt; gt; I have this dilemma. I have a number in column B of spreadsheet one. I need
gt; gt; gt; to split that number and put the first 8 digits into column D of another
gt; gt; gt; spreadsheet.
gt; gt; gt;
gt; gt; gt; Here's what it looks like.
gt; gt; gt;
gt; gt; gt; Spreadsheet one, Column B: 12345678_987654321
gt; gt; gt;
gt; gt; gt; I need to put into spreadsheet two, Column D: 12345678 from spreadsheet one.
gt; gt; gt;
gt; gt; gt; Spreadsheet one, Column D has number 987654321. I need to use this as an
gt; gt; gt; anchor to put the right numbers from spreadsheet one, column B into
gt; gt; gt; spreadsheet two, column D.
gt; gt; gt;
gt; gt; gt; THANK YOU!!!

That won't anchor me, will it?

Let me explain better.Sheet 1.

Column B Column C
NUM NAME
987654321 12345678 987654321Sheet 2.

Column E Column D
ID SEC NUM
987654321 (I need this to say) 12345678

From S2, column E can hook into S1, column B. I need the first 8 characters
of S1, column C to go into S2, column D.
quot;paulquot; wrote:

gt; say in d2 of sheet2 =LEFT(sheet1!B2,8)
gt;
gt; --
gt; paul
gt; remove nospam for email addy!
gt;
gt;
gt; quot;Paperback Writerquot; wrote:
gt;
gt; gt; I have this dilemma. I have a number in column B of spreadsheet one. I need
gt; gt; to split that number and put the first 8 digits into column D of another
gt; gt; spreadsheet.
gt; gt;
gt; gt; Here's what it looks like.
gt; gt;
gt; gt; Spreadsheet one, Column B: 12345678_987654321
gt; gt;
gt; gt; I need to put into spreadsheet two, Column D: 12345678 from spreadsheet one.
gt; gt;
gt; gt; Spreadsheet one, Column D has number 987654321. I need to use this as an
gt; gt; anchor to put the right numbers from spreadsheet one, column B into
gt; gt; spreadsheet two, column D.
gt; gt;
gt; gt; THANK YOU!!!

say in d2 of sheet2 =LEFT(sheet1!B2,8)

--
paul
remove nospam for email addy!quot;Paperback Writerquot; wrote:

gt; I have this dilemma. I have a number in column B of spreadsheet one. I need
gt; to split that number and put the first 8 digits into column D of another
gt; spreadsheet.
gt;
gt; Here's what it looks like.
gt;
gt; Spreadsheet one, Column B: 12345678_987654321
gt;
gt; I need to put into spreadsheet two, Column D: 12345678 from spreadsheet one.
gt;
gt; Spreadsheet one, Column D has number 987654321. I need to use this as an
gt; anchor to put the right numbers from spreadsheet one, column B into
gt; spreadsheet two, column D.
gt;
gt; THANK YOU!!!