Excel Macro

[EBenoit84]

Hello,

I am looking for an Excel 2003 macro that will concatenate 'X' number of columns together (starting at column 'B', trim and intrim (to remove the blanks), then do like a text to column split on the ' ' (space). Even if the text to column split part is done in a seperate macro, that would still be fine.

If this is possible please let me know.

Thanks in advance.

 

[SkipVought]

Please post in forum707, for vba (macro) help.

Also post an example of the data you have, that illustrates the ' ' (space) case and expalin how removing spaces will leave the data with a ' ' (space).

Explain how you want x defined for "x columns"

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}