Separate plain text in one access field into multiple fields?

[Veronicaatups]

I need to find out how I can separate plain text in an Access field into
multiple fields in Excel. The text is separated by commas.

 

[Mr B]

This is really a question for an Excel newsgroup.

However, try this:
Just copy the data to Excel then try using the "Text to columns" option from
the Data option on the pull down menu. One of the options is for delimited
text. Using this will seperate the data into individual columns.

 

[John Vinson]

I need to find out how I can separate plain text in an Access field into
multiple fields in Excel. The text is separated by commas.

This is probably more easily done in Excel (using Text to Columns, a
feature which does not exist in Access); but take a look at the VBA
help for the "Split" function for a possible alternative.

John W. Vinson[MVP]

 

[Veronicaatups]

Thank you, this helps.
Veronica

This is really a question for an Excel newsgroup.

However, try this:
Just copy the data to Excel then try using the "Text to columns" option from
the Data option on the pull down menu. One of the options is for delimited
text. Using this will seperate the data into individual columns.