This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I am having issues using Text to Column in order to split consecutive digits into two columns to ultimately run a chart of accounts. Is there also a way I can assign these fields a title (I.E. 11 = Current Asset, 12 = Non-Current Asset etc)
From
Field 1 |
110002 |
111003 |
123003 |
124001 |
210011 |
221003 |
To
Field 1 | Field 2 |
11 | 0002 |
11 | 1003 |
12 | 3003 |
12 | 4001 |
21 | 0011 |
22 | 1003 |
Solved! Go to Solution.
Thanks Mark, that worked well! Love your work.
Any idea how to now assign a title to consecutive digits? I.E. 11 = Current Assets, 12 = Non-Current Assets etc
Cheers,
Tom
You can use the select tool to rename the headers
Flow:
Select:
Nevermind, misinterpreted the question. @MarqueeCrew is spot on with the switch.
Thanks mate, that's worked well.
@JoshKushner Select Tool is what I was looking for, thanks!