Home |
Search |
Today's Posts |
#1
|
|||
|
|||
VBA code to split text data from a cell into multiple cells/rows
Hello All,
I need your help with a VBA code which should split the wrapped text from a cell, into multiple cells / rows. It can be based on a carriage return "#" or only as it is now, extracted directly SP Online. When finding an empty cell /carriage return, I will need to leave that cell empty. The current text is exported from SP Online list, as wrapped text - due to some merged fields from some repeating table from InfoPath. The field from the repeating table can only be promoted in SP Online as "merged" . Therefore it is a must to split the data into multiple cells in Excel, to be able to filter correctly the data. I tried different macros with no luck. I also was able to add "#" as carriage return after each statement from that cell. The splitting itself it does not work. Attached is the spreadsheet example with the expectation. Thanks a lot in advance for your support. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
VBA code to split text data from a cell into multiple cells/rows
Hi Alice,
Am Wed, 22 Jun 2016 15:58:28 +0100 schrieb alicedb: Attached is the spreadsheet example with the expectation. there is no attached workbook. Regards Claus B. -- Windows10 Office 2016 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to split one cell into multiple rows? | Excel Discussion (Misc queries) | |||
Need to split a cell into multiple rows | Excel Programming | |||
Split text to multiple cells | Excel Worksheet Functions | |||
How to combine multiple rows of text cells into one cell | Excel Discussion (Misc queries) | |||
split text in one cell into multiple cells without breaking the wo | Excel Worksheet Functions |