How ohhh how?

  • Thread starter Thread starter Scott Viney
  • Start date Start date
S

Scott Viney

G´day All,

I have something that is driving me insane.

I have a some data output from an accounting package. The data is the list
of all the products that is in the package.
But the problem is that everything is included in the product description

EXAMPLE

ACOPLE PARA CAVITRON
ACOPLES PARA MANGUERA
ACRILICO AUTO ESTUCHE (6P/1L) JET
ACRILICO AUTO LIQUIDO*120CC JET
ACRILICO AUTO POLVO QUIMIDENT X KILO
ACRILICO ISOTHERMICO FRASCO
ACRILICO LIQUIDO AUTO GALON QUIMIDENT
ACRILICO LIQUIDO AUTO*125CC QUIMIDENT
ACRILICO LIQUIDO AUTO*250CC QUIMIDENT
ACRILICO LIQUIDO AUTO*60CC QUIMIDENT
ACRILICO LIQUIDO CORRIENTE*125CC QUIMIDENT

How can I split certain data into different columns. In reality I want to
search with wildcards and cut out the information and paste it into a new
column

Any ideas on how I can achieve this, cheers,

Scott V
 
Hi Scott

Select the cells and play with menu Data > Text to columns.
(Play with indicates "test on a backup first" :-)

HTH. Best wishes Harald
 
Back
Top