using text to column in VBA

[c.vaibhav]

Hi,

I have a text in a single cell that has spaces, commas, excalamations, question marks etc. I want to convert this text into columns using text to column feature of excel in my macro..

when i record text to column it does not give me a code that could be made dynamic..

Can any one please suggest me a better way to do that?

Regards,
Vaibhav

[Andy Pope]

In what way do you want to make it dynamic?

Please Login or Register  to view this content.

[Marcol]

Can you be a bit more explicit?

Post a worksheet with some examples of your strings, and how and where you would like them to end up.

[EDIT]

Simultaneous postings

Andy has given you the basic code

[c.vaibhav]

Thanks Andy.. thats exactly what i wanted..

thank you very much..

Regards,
Vaibhav

[c.vaibhav]

Here if we have multiple delimiters then how do we incorporate in the code..

like here in your case you have used "!", but I would like to use "&", "^", and many other.

[Andy Pope]

The delimiter is a single character.

To do multiple delimiters you will need to write code.

[c.vaibhav]

okay.. thanks..

i thought there would be some internal function of excel..

Regards,
Vaibhav