Extracting Info from within a cell multiple times
 

I receive a report in Excel that I re-format for my needs, and I need some
help, please!
Column E contains account numbers. Each account number is 7 digits (numbers
& letters). The report comes in with 5 account numbers on a row; if there are
more than 5 account numbers, there is a carriage return, then 5 more account
numbers, and so on. There are never more than 5 rows of account numbers in a
cell.
I need my final document to have each account number in it's own cell, but
only 5 across, then fill the row below, five across, then below. Cells A-D
contain company information, which I can fill after I've inserted rows.
I've tried replacing all the carriage returns and using text-to-column, but
then it takes forever to move things around.
I found on here where I can use the LEFT function, and return all
informaiton before the carriage return; is there any way to then pull the
information from BETWEEN the carriage returns, and how would I specify which
returns?
I currently have the left function in cell F3; if I could fill g3, h3, i3,
etc with additional formulas to pull from between the returns, that would be
perfect! I think I could figure the rest from there.
I hope that made sense.... Thank you in advance!!!

Extracting Info from within a cell multiple times
 

Nevermind!
I used the MID function, 5 times (once for each row in the cell, out to the
right.
Thank you anyway!

"o1darcie1o" wrote:

I receive a report in Excel that I re-format for my needs, and I need some
help, please!
Column E contains account numbers. Each account number is 7 digits (numbers
& letters). The report comes in with 5 account numbers on a row; if there are
more than 5 account numbers, there is a carriage return, then 5 more account
numbers, and so on. There are never more than 5 rows of account numbers in a
cell.
I need my final document to have each account number in it's own cell, but
only 5 across, then fill the row below, five across, then below. Cells A-D
contain company information, which I can fill after I've inserted rows.
I've tried replacing all the carriage returns and using text-to-column, but
then it takes forever to move things around.
I found on here where I can use the LEFT function, and return all
informaiton before the carriage return; is there any way to then pull the
information from BETWEEN the carriage returns, and how would I specify which
returns?
I currently have the left function in cell F3; if I could fill g3, h3, i3,
etc with additional formulas to pull from between the returns, that would be
perfect! I think I could figure the rest from there.
I hope that made sense.... Thank you in advance!!!