Manipulating VBA Text To Columns

[googlebot]

Hello,

I have the following code:

Please Login or Register  to view this content.

I have bolded the relevant text. I am wondering if there is a way to specify ALL columns have the value 2 instead of just the ones that I have listed there. Otherwise I will have to go

Please Login or Register  to view this content.

and etc.

Thanks in advance!

[lecxe]

Hi googlebot

I don't think there's a solution inside the TextToColumns method. You can, however, use an array:

Please Login or Register  to view this content.

[pike]

Post removed