Separate plain text in one access field into multiple fields?

G

Guest

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.
 
G

Guest

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.
 
J

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.
Click to expand...

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]
 
G

Guest

Thank you, this helps.
Veronica

Mr B said:
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.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Text and Memo field concatenation - Line break (Access 2007) 4
Separate Names 3
Importing Text Files Into Access 1
Splitting fields in access 2010 0
Help parsing text field in access 3
Sorting Alpha numeric data and keeping the number sequence 5
Identifying single values in a field that stores muliple valuesseparated by a comma 10
Splitting a field 4

Top