possible?

[ChrisDo11]

i have a table that has company names. the field as the company name, address, street #, postal code.

is there a way to use a query to make another table where this field is separated into 2 fields? field one = company name, field two = address??

Thanks,

 

[Fornatian]

It can be done if there is some feature of the data which would identify the parts, are they split by commas? Maybe post some sample data so we can judge the options.