Split specific data from one cell to other cells

[AaruJaan]

Hi Experts,

I have huge data in file, I'm facing issue in one column, I need to split specific data into specific column, I'm sending file and screenshot, please check the attachments.

Thanks in advance.

Farhangul

[JohnTopley]

Please post a larger sample of "Founders" data (Column I) so there is true representation of the variability.

[AaruJaan]

Thanks for reply john, I also attached excel file, you can check there, can you please help me on this issue?

[JohnTopley]

I have no idea how this might be done (it is VERY fuzzy logic) as there are no obvious "delimiters" with a very variable number of lines between data to be captured.

It certainly will require a VBA-based solution but even that looks impossible.

[AaruJaan]

ok john. thanks for try.

[samba_ravi]

m3

Please Login or Register  to view this content.

n3

Please Login or Register  to view this content.

o3

Please Login or Register  to view this content.

Try this and copy and paste the formula in respective fields

[JohnTopley]

@Siva: very impressed though I have not "deciphered" the formulae!