Can I convert text to columns in a query?

M

Michelle

Can I convert text to columns in a query? I know I can do it in Excel, but
I'd rather not have to maintain a linked Excel table in my query. Here's the
field that I'm trying to seperate:

Field 1:
2.00% @ 24 3.00% @ 24 4.00% @ 48

I want it to show up in my query as six different fields, like this:

Field 1: Field 2: Field 3: Field 4: Field 5: Field 6:
2.00% 24 3.00% 24 4.00% 48

Is this possible?
 

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

Can I convert text to columns in a query? 2
relective formula 0
Cumulative time calculation in Excel 2003 3
Assistance in modifying a formula 0
repeated conversion of data summarized into rows and columns 4
Combining rows in query 4
Visio: copy text of a master shape to User-define Cells (Variable) 0
Word Template where user inputs <TITLE> and then that can be displayed in footers or headers [MAC] 0

Top