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!!!