Hi
I am looking for something to assist me in changing the following type of text:
15-080 3 000 2,868,938,288 5,984,479,335 -52
Into
2,868,938,288
5,984,479,335
So basically a formula or something to only keep the two string values where they contain commas.
Note that the initial string can be longer, but will always have 2 strings which have commas in.
Thanks in advance
Solved! Go to Solution.
Hi @MorneViljoen,
Text to columns will help you with this task. After you create a row for each position you can simply filter out rows that you don't need.
The output:
@Emil_Kos Thanks, this could work, but one thing I forgot to mention is that I have multiple rows like that (see attached) which would need to be changed. Also added how I think the output should look which I forgot to mention previously.
Thanks this is working great
@Emil_Kos I tried this one but the column did not format like it should.
But the regex one worked great.