Make sure the column to the right is empty, then do datatext to columns,
select fixed width, click next and click where you want the split. If there
can be different strings with different lenght you can use a formula to find
for instance the question mark

=TRIM(MID(A1,FIND("?",A1)+1,255))

Regards,

Peo Sjoblom

"RTP" wrote:

I have a column and its contents is a question which states...

What is the Cost of Superbills? Quantity of:

I would like to split this lone cell and have the quantity right next to the
question. Can I do this???