How to easily copy existing information into a record as a list

[turneg02]

eg

sugar,* beans ,* water

and i want it to stored as

sugar
beans
water

in the access database
i could copy make them into a list like that and then paste it in correct
cell but theres thousands of records so im looking for a quick and easy way

thanks

 

[Rick B]

What are you trying to accomplish?

Your post is not clear. Also, you are using terms like "cells" which refer
to Excel, not Access.

 

[John Vinson]

eg

sugar,* beans ,* water

and i want it to stored as

sugar
beans
water

in the access database
i could copy make them into a list like that and then paste it in correct
cell but theres thousands of records so im looking for a quick and easy way

thanks

You'll need some VBA code to parse the text string into components,
using the Split function. I'm not sure I understand the format: what
are the asterisks? Are they just delimiters that you want to get rid
of? What about the (inconsistent) leading and trailing blanks?

John W. Vinson[MVP]