Forum

Notifications
Clear all

TextSplit

4 Posts
2 Users
0 Reactions
42 Views
(@rickdhiman)
Posts: 3
Active Member
Topic starter
 

I have one cell with multiple items.

How can I split one cell into multiple rows?  I don't have a unique Delimited.  I tried Textsplit, but getting errors.  Any help is greatly appreciated 


 
Posted : 04/10/2025 2:13 pm
(@rickdhiman)
Posts: 3
Active Member
Topic starter
 

Can you show me how to use Textsplit or the formula 


 
Posted : 04/10/2025 2:17 pm
Alan Sidman
(@alansidman)
Posts: 242
Member Moderator
 

Since you have three columns of data, please mock up how you would like the result to look like.  I want to be sure we supply the right answer before going forward.  Also, which version of Excel are you using?


 
Posted : 04/10/2025 2:20 pm
(@rickdhiman)
Posts: 3
Active Member
Topic starter
 

Hi Alan 

Microsoft® Excel® 2019 MSO (Version 2509 Build 16.0.19231.20138) 64-bit

Row 1 is the download file, from the application. 

I would like to see TextSplit output like in row 4 


 
Posted : 04/10/2025 2:36 pm
Share: