VBA to format imported document

[rs1aj]

I've attached a file where on the left is what I get imported from our system here at work. To the right is what I would like to end up with.

I'm on page 137 of John Walkenbach's "Excel 2007 Power Programming with VBA". It's over 1000 pages so I'm not quite how to do this yet but I'm learning. Any help would be appreciated. Thank you!

[jaslake]

Hi rs1aj

Try this Code in the attached...CTRL + x will fire the Code.

Please Login or Register  to view this content.

[rs1aj]

This works perfect. Thank you for your time doing this.

Now, lets see if I can figure out how you did this so I can do this sort of thing in the future by myself.

[Winon]

@jaslake & rsiaj,

Very well done jaslake.

Maybe you guys would want to consider adding the Trim function to the Code, just for in case leading or trailing spaces may happen.

Regards.

[jaslake]

@rs1aj

You're welcome...glad I could help. Thanks for the Rep.

@Winon

Thanks for the kudos and thanks for the Rep.