Forum Discussion
How to split my text which I can say it is complex!
- 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.
syazaaoa95 This is very easy using Data, From range/Table.
I did this:
- Copied column A to another worksheet
- Added a heading and selected Data, From Range/Table
- Use Split column by delimiter
- Set " IR" as the delimiter (excluding the quotes)
- Selected left-most delimiter
- Clicked Close & Load drop-down and chose "Close & Load to..." and opted to load to a table.
And also what if there some descriptions does not have IR? What should I do?
- JKPieterseMay 03, 2023Silver Contributor
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.
- syazaaoa95May 04, 2023Brass ContributorWhat if I don't have TEXTSPLIT function? can I use this in google spreadsheet too?
- JKPieterseMay 04, 2023Silver ContributorI don't know, I don't use google sheets