Indent move cell, 2 indent move 2 cells etc

**jomuir** · 05-14-2012, 11:18 AM

I have a 103 page word document, and it contains a long list with bullet points (simliar to below) and when I copy and paste it into excel all the data goes into column A. However all Level 2 pages are indented, level 3 pages are indented twice, Level 3 are indented three times and so on upto 7 levels.

How can I get all the level 2 text to move into column B, level 3 text into column C etc? I need to keep them in the same order, so I know which set of data is a sub set.....(sorry, should say I am using Office 2010)

Level 1

Level 2

Level 3

Level 4

Level 2

**Russell Dawson** · 05-14-2012, 11:24 AM

Hi

Text to columns comes to mind but without seeing your source data it's hard to help. Can you upload the file or is there sensitive data that prevents you from doing so? Is it just a one off exercise? Why do you need to do it? I would be interested to know what your long term goal is.

Regards

**jomuir** · 05-14-2012, 11:37 AM

I thought about that, but there is not an option for indent and not sure what I could enter in the other box for an indent?

Here is a small sample of the word doc and the excel doc after copy and paste.

Hopefully it is a one off, but could change? I will be working different levels at a time and I believe it will be the easiest way of viewing that data at a glance.

**Russell Dawson** · 05-14-2012, 11:56 AM

Don't think I can come up with a solution.

My best offer would be to cut at the first indent and copy all to column B then do the same for the next indent and so on. But that's something you could do within Word anyway.

There will no doubt a way to do it with VBA and I would suggest that you repost this with a title such as - "VBA to move indented text to next column" in the Programming sub Forum.