Forum Discussion

syazaaoa95's avatar
syazaaoa95
Brass Contributor
May 03, 2023
Solved

How to split my text which I can say it is complex!

Below here is my https://docs.google.com/spreadsheets/d/1VZtNFdR46_c7b6GitMaazC8nU2lGDxbn-Z1kmy0jSyQ/edit?usp=sharing . You may try to see my text and how am I trying to split it. But it seems qui...
  • JKPieterse's avatar
    JKPieterse
    May 03, 2023

    syazaaoa95 Hmm. Does your Excel have the TEXTSPLIT function? If so, you could use that to retrieve the first part of the strings like so:

     

    =TEXTSPLIT(Table2[Data],{"IR","NP","GP"," L1"," CF"," DR"," C1"," CLC"})

     

    You'll have to look at the results to see if any remain "unsplit" and find out which characters you can add to split that one as well. Watch out though, adding texts to the strings within the curly braces may affect ones that have currently been correctly split into ones that are now split the wrong way!

    See attached.

Resources