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.
Hope you are well. I need help. I have column and i need to extract the text from the column.
Please find attached the input and output.
Sorry @sriniprad08 just seen your post about removing the brackets,
A couple of ways to do this, if it's just brackets then this formula will do the trick
Alternatively you can use a RegExReplace() to remove anything which isn't a letter, number, underscore or hyphen with this:
To add to above another option to remove brackets is using Trim function like below.
Hope this helps : )
Hi @atcodedog05 ,
Thank you for the help 🙂 Can you please help me one more thing ? Please find attached the input and the output.
The only difference is the one marked in red should be there in the ouput. thanks again.
Give this a try.
Thank you very much :). I will go through it and let you know.