One more method......

Select the cell with 1,2,3,4

EditReplace

what: ,

with: ALT + 0010(on numpad)

Replace all.

F2 to edit. Select data in formula bar and Cut.

Select B1 and Paste


Gord Dibben MS Excel MVP

On Fri, 30 Jun 2006 06:53:58 -0500, guyvanzyl
wrote:


Now I know why they call you 'StarGuy'

Thanks a million, much appreciated