Split cells

Question

Hello,

Answer 1

Hi

It is difficult to visualize your requirement with the current information, your workbook is too complex to give you a solution without having access to your file.

Kindly suggest prepare and upload a sample file to Onedrive, Dropbox, etc ... and share the link here

Please,

a)  Remove any personal/sensitive data

b) Keep the headers, table structure, and formulas as they actually are

c) ZIP the file if contains macros, shapes, or other objects.

d) Provide more details of your scenario and goals. Also, post the results expected.

It will help us to give you a prompt and right solution.

If you need help with how to upload the file please, click the link below

https://support.office.com/en-us/article/share-onedrive-files-and-folders-9fcc2f7d-de0c-4cec-93b0-a82024800c07

You may also try

https://www.youtube.com/watch?v=NnXsE0SNuCc&t=14s

Regards

Jeovany

Answer 2

Hi,

You may download my solution workbook from here. Add data by rows to the blue range and click on Data > Refresh All.

Hope this helps.

Answer 3

Put below formula in A2 and it will spill into all required cells automatically

=FILTERXML("<t><s>"&SUBSTITUTE(A1,CHAR(10),"</s><s>")&"</s></t>","//s")

It will not replace the value in A1. If you want values starting A1, then VBA code will be required. But I think you should not need this as it preserves the original value.