Move text to next column macro

[falconmm]

Hey all,

All I need is the code for a macro that moves certain text after a point to the next column.

I only use the first column, and it's consisted of Email: followed by an email address. Example:

Email: example@example.com
Email: example2@example2.com

All I need is a macro that will move everything after Email: to the next column. Thanks!

~Zephyr~

 

[AlphaFrog]

You could use the Text to Columns feature and use a space as the delimiter.