Text To Columns - Separate text from number

KellyPoling 

With second question bit easier - just assign Text type to all resulting column (with Text to Columns on 3rd step of the wizard select all columns and assign Text).

With separation is harder, afraid some manual work will be required in any case. First, the logic of separation is not formalized. If, for example, you'd like to separate

Casillero del Diablo Sauvignon Blanc Reserva 750 ml on 

Casillero del Diablo | Sauvignon Blanc Reserva | 750 ml

you can't say that text shall be split on each 3rd and 7th space since for each record this logic is different.

You may wrap all brands and name by apostrophes , e.g Ctrl+H and Replace All Casillero del Diablo on "Casillero del Diablo". With splitting on columns above will be treated as one word. But that could be a lot of work plus punctuation of names is different ( Casillero del Diablo and CasilleroDel Diablo; 750ml and 750 ml).