[Jackson]

I have large txt files and need to change format from;
first,last,email,address,etc to a file with- email last first address.
Nothing but the 'tab' between. How can I do this with 'auto-format' feature?

[JoAnn Paules [MVP]]

Covert the text to a table, rearrange to suit, convert back to text.

--

JoAnn Paules
MVP Microsoft [Publisher]




"Jackson" wrote in message
...
I have large txt files and need to change format from;
first,last,email,address,etc to a file with- email last first address.
Nothing but the 'tab' between. How can I do this with 'auto-format'
feature?

[Jackson]

Joann I tried this but after changing back to text the , are still present in
the files. Is there a way to eliminate all scripting of , or " with just a
'tab'-space between?

"JoAnn Paules [MVP]" wrote:

Covert the text to a table, rearrange to suit, convert back to text.

--

JoAnn Paules
MVP Microsoft [Publisher]




"Jackson" wrote in message
...
I have large txt files and need to change format from;
first,last,email,address,etc to a file with- email last first address.
Nothing but the 'tab' between. How can I do this with 'auto-format'
feature?

[JoAnn Paules [MVP]]

Replace the commas with a tab after it's converted back.

--

JoAnn Paules
MVP Microsoft [Publisher]




"Jackson" wrote in message
...
Joann I tried this but after changing back to text the , are still present
in
the files. Is there a way to eliminate all scripting of , or " with just a
'tab'-space between?

"JoAnn Paules [MVP]" wrote:

Covert the text to a table, rearrange to suit, convert back to text.

--

JoAnn Paules
MVP Microsoft [Publisher]




"Jackson" wrote in message
...
I have large txt files and need to change format from;
first,last,email,address,etc to a file with- email last first address.
Nothing but the 'tab' between. How can I do this with 'auto-format'
feature?