Hi All,

I have encounter for text to column. my data is as below

Range ("A1")=2008 76 294 (0) 69 683 (+7) 145 977 (+3) 43 021 (+18) 70 404 (+4) 113 425 (+9) 259 402 (+6)
Range("A2"=2009 76 240 (0) 63 053 (-10) 139 293 (-5) 38 626 (-10) 65 048 (-8) 103 673 (-9) 242 967 (-6)

the first word of the sentence is year and the separator is the bucket. I need to remove space in the data.
I want the table to be as below

2008 76294 69683 145977 43021 ...
2009 76240 63053 139293 38626 ...

I think the difficult to change the bucket to a separator.
Thanks in advance.