Format Data based on an IF STATEMENT on how many empty spaces in a cell

Hi

Struggling here to find a solution maybe someone here can lend there expertise.

I have data file and i need to sort them into columns. All the data to sort is in column A with certain blank spaces before the value in the cell that determines its type and want to copy to another column.

This is what I have currently that i m trying to building on. This is just a synopsis.

My question is how to get the if statement to work to figure out the blank space before each cell text.

Sample:

Type (3 spaces)
Seller (5 spaces)
Manufaturer (7 spaces)
Product (9 spaces)
Detail (11 spaces)
Description (13 spaces)
Product (9 spaces)
Detail (11 spaces)
Description (13 spaces)

Please Login or Register  to view this content.

Hope this detail makes sense and someone can help.

Not quite sure what you are trying to achieve. You want to sort the data and placed into another column ?

OllyXLS great piece of code, working now with minor modification to suit my file see below for anyone with the same problem.

THANKS!!

Please Login or Register  to view this content.

Thanks this is great.