Split into two cells

[adamsm]

Hi anyone,

I'm trying to figure out a formula that would copy and paste the value in cell contents in from column I of the sheet CustomerMasterList into cells D13 & E13 of the sheet "NewInvoice".

Lets say for example column C of the sheet "CustomerMasterList" has A123456. And column I of the same sheet has 24 Years(in the same row).

What I want is when I write A123456 in cell D10 of the sheet "NewInvoice" the cell content of column I that is 24 Years; to get copied into D13 and E13.
Meaning, 24 to cell D13 and Years to E13.

Any help on this would be kindly appreciated.

Thanks in advance.

 

[cjcobra]

I would do a VLOOKUP(LEFT,2) and VLOOKUP(RIGHT,5) from your Main sheet. If the number of years varies, Use a LEN to get the length of the text. If it's 8 char long, then RIGHT,2, if it's 7 char long, RIGHT,1.

 

[adamsm]

Thanks for the reply. I would be happy if you could provide a sample formula to so.

Thanks in advance.