Forum Discussion

Anıl Adaş's avatar
Anıl Adaş
Brass Contributor
Jul 11, 2018

Seperate similar words to columns HELP PLS

In the excel example picture below, how can I separate ALL COLUMNS like that:

 

Original:

AASE PLASTIK SAN VE TIC ASTR0860485160TUZLAmuhasebe@asepack.com

 

Needed: 

AASE PLASTIK SAN VE TIC AS should be in column B

TR0860485160 should be in Column C

TUZLA should be in Column D

muhasebe@asepack.com should be in Column E

 

 

1 Reply

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Rather than a picture can you post some sample data (more than just one) and the expected end result?

Resources