Split text by replacing certain characters before

[zelarra]

Hello. I have a text that I want to split into columns, but I want to first pass a replace to it so that it changes the wrong values. Well, I've managed to do the latter, but I can't create an array that shows me all the rows without scrolling the formula down.

I am attaching the Excel so you can see what I have done and what I want to achieve.

Thank you so much.

All the best.

 

[rondeondo]

Hi Zelarra,
do you want to split by a fixed number of characters or split at a particular character.
Either way can be achieved with a combination of left(), mid() and right() with either fixed numbers for repeated character count or use of find() to split at specific charcters. You can post a sample sheet showing the starting data and how you want the results and any logic to apply, this will help with a specific solution

 

[zelarra]

Hi. I've solved. I used split text in columns. Thanks a lot.