Siddhu11011
Board Regular
- Joined
- Jun 22, 2022
- Messages
- 56
- Office Version
- 365
- Platform
- Windows
I just want to exclude data inside the small brackets along with brackets in excel.
ex. 1) ader25a (06/12/2022 - 06/13/2022)
2) ader25a (06/12/2022 - 06/13/2022)asde5942sd (05/05/2021 - 05/16/2021) sdfgtr12ed(09/12/2021 - 09/29/2021)
3) ader25a (06/12/2022 - 06/13/2022)asde5942sd (05/05/2021 - 05/16/2021)
4)12248fg
5)ader25a (06/12/2022 - 06/13/2022)asde5942sd (05/05/2021 - 05/16/2021) sdfgtr12ed(09/12/2021 - 09/29/2021)asde5942sd (05/05/2021 - 05/16/2021)
I want the output:
1) ader25a
2) ader25a & sde5942sd & sdfgtr12ed
3) ader25a & asde5942sd
4)12248fg
5)ader25a & asde5942sd & sdfgtr12ed & asde5942sd
One more thing, I have applied formula in which some functions are combined such as Trim, Clean, IFERROR, and MID are used. I just want solution which can be applied like this: =New Function(Trim(Clean(IFERROR(MID....
Above 5 examples are the end result of my formula. Please suggest any formula which I can use to exclude above mentioned data.
ex. 1) ader25a (06/12/2022 - 06/13/2022)
2) ader25a (06/12/2022 - 06/13/2022)asde5942sd (05/05/2021 - 05/16/2021) sdfgtr12ed(09/12/2021 - 09/29/2021)
3) ader25a (06/12/2022 - 06/13/2022)asde5942sd (05/05/2021 - 05/16/2021)
4)12248fg
5)ader25a (06/12/2022 - 06/13/2022)asde5942sd (05/05/2021 - 05/16/2021) sdfgtr12ed(09/12/2021 - 09/29/2021)asde5942sd (05/05/2021 - 05/16/2021)
I want the output:
1) ader25a
2) ader25a & sde5942sd & sdfgtr12ed
3) ader25a & asde5942sd
4)12248fg
5)ader25a & asde5942sd & sdfgtr12ed & asde5942sd
One more thing, I have applied formula in which some functions are combined such as Trim, Clean, IFERROR, and MID are used. I just want solution which can be applied like this: =New Function(Trim(Clean(IFERROR(MID....
Above 5 examples are the end result of my formula. Please suggest any formula which I can use to exclude above mentioned data.