| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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!!! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell References | Excel Discussion (Misc queries) | |||
| Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
| How to create/run "cell A equals Cell B put Cell C info in Cell D | Excel Discussion (Misc queries) | |||
| Converting string of info in one cell into multiple | Excel Discussion (Misc queries) | |||
| enter a time into a cell, have the cell show two times the entry | Excel Worksheet Functions | |||
Linear Mode
