Forum Discussion
text to row function
I have data that is exported from an application that puts mutiple rows of data in a single cell. I need to extact those embedded rows from cell and put into their own rows!! Show me the way please...
fploof Can you show an example of how it looks like? What Excel version are you using?
- "Date : 3/18/2024, Amount: 180.00, Description: 2 nights Motel 6 - Repaid 100.00 owes 80
Date : 3/24/2024, Amount: 90.00, Description: Zelle for one night at Motel 6
Date : 3/24/2024, Amount: 90.00, Description: Zelle - 1 night Motel 6 Orangeburg
Date : 4/10/2024, Amount: 50.00, Description: Deposit Budget Inn - Refunded in 3 days
Date : 4/12/2024, Amount: 250.00, Description: 1/2 pay for one week Budget Inn
Date : 4/26/2024, Amount: 73.00, Description: 1 night Arrow
Date : 5/2/2024, Amount: 50.00, Description: Cost Less food voucher
"
***Don't know Excel version, sorry***
If those are line breaks in the cell (e.g Ctrl+J), then try this:
=LET(line_break, CHAR(10), TEXTSPLIT(A1, , line_break))- Sorry, but I have no idea where to insert this. I have 1 colunm with 478 rows and about 100 cells have these types of entries...
No need to apologize. Here's a sample workbook with the formula.
