Hello,
I want to find and remove text from the rows in whole excel sheet except specific text after decimal (dot).
Example: Except "Ax.Frameworks.Name" and "Ax.Frameworks.Header", Remove anything after 2nd dot i.e, in excel if it is "Ax.Frameworks.ID" , then remove "ID" and change it to "Ax.Frameworks".
Note: ID will be replaced with many other texts
Please somebody provide vba/macros.
Last edited by MohammedAsif10000; 03-21-2022 at 02:56 PM.
Hi and welcome to the forum.
In the adjacent column then use
=SUBSTITUTE(A1,".ID","")
If necessary copy this column and paste as Values back on top of the original.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Thanks, but ID will be replaced by many other texts, so I'm looking for vba/macros.Originally Posted by Richard Buttrey
Please Login or Register to view this content.
It's important when you post an example to be quite clear whether it tells the whole story.
You should also upload a workbook that truly represents your data. One example simply isn't good enough.
An Excel function is still available. Simply use
=IF(ISERROR(MATCH(RIGHT(A1,LEN(A1)-FIND("^",SUBSTITUTE(A1,".","^",2))),"exclude_items_range",FALSE)),A1,LEFT(A1,FIND("^",SUBSTITUTE(A1,".","^",2))-1))
where "exclude_items_range" is a range of cells that should be ignored.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks