Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 1
Exclamation 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,872
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to split one cell into multiple rows? wondering Excel Discussion (Misc queries) 2 April 3rd 23 10:55 AM
Need to split a cell into multiple rows [email protected] Excel Programming 2 April 1st 08 06:59 PM
Split text to multiple cells Lauren H Excel Worksheet Functions 4 July 2nd 07 02:51 PM
How to combine multiple rows of text cells into one cell [email protected] Excel Discussion (Misc queries) 2 October 19th 06 01:19 PM
split text in one cell into multiple cells without breaking the wo Prashant Excel Worksheet Functions 3 March 6th 06 09:48 AM


All times are GMT +1. The time now is 08:40 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"