Hello,
I am trying to solve exercise 3 from EC_Client Data but I have some difficulties to separate the name of the item and the number between brakets. How can I do it?
. Activism (42)
I haven't had any problems in extracting the point and spaces with the formula =EXTRAE(B7;11;30) but I can't extract the (42) by using the formula =EXTRAE(C7;BUSCAR(" ";C7);5)
Thanks in advance,
Cristina
Hi Cristina,
Looks like you are using the EXTRAE function (which I think is equivalent to MID in the English version). The section of the course refers to the Text To Columns method for separating data, and in this case, Text To Columns provides a very simple method to separate this text from the numbers, without using any formulas that need to be copied down.
I made a short video to show you how to use it in this case. The link is:
https://www.dropbox.com/s/8n7j838tyryhmeo/Text%20to%20Columns%20exercise.mp4?dl=0
Cheers,
Harold
Hello Harold,
Thanks so much for your answer and video. Much more easier than I thought. It is crystal clear now 🙂
Best,
Cristina
