Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 03-16-2022, 05:08 AM
ranjan ranjan is offline Text removal Windows 10 Text removal Office 2019
Advanced Beginner
Text removal
 
Join Date: May 2021
Posts: 80
ranjan is on a distinguished road
Default Text removal

I have a document with a dual presentation Native and English, the presentation is like “NATIVE TEXT/ENGLISH TEXT”, and I need to remove only the native text before the backslash.



If the text before the backslash is anything other than English or Numbers It should get deleted along with the backslash.

Can Macro/Wdreplace be used to remove the text before the back slash? If so, could you please assist me in this regard.

Although I'm not quite sure if we could automate this work or not, if it doesn't seem realistic, please excuse me…

In a table, each line item containing a dual language is presented in a separate cells, and text before the backslash to the begging point of the cell should be deleted if the text is other than English and numbers, please see the below example.

I really appreciate your help and my sincere gratitude goes out to you for your support.

Input:

Harga Perolehan/ Acquisition Cost
Nilai Aset Neto/ Net Asset Value
Penurunan Nilai Goodwill/ Goodwill Impairment
Goodwill Neto/ Goodwill Net
Income/Loss
234/989

Output:
Acquisition Cost
Net Asset Value
Goodwill Impairment
Goodwill Net
Income/Loss
234/989
Attached Images
File Type: jpg Capture 6.JPG (117.4 KB, 45 views)
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Removal of resource calendars? Snoboy Project 0 10-07-2020 12:28 PM
pst password removal darnero Outlook 0 03-07-2018 07:24 AM
Text removal Removal first 7 typos Chetan Seebra Excel Programming 2 03-31-2015 12:57 PM
Text removal table removal syntax EAGLE SEU Word VBA 5 01-23-2015 10:57 AM
Text removal Field removal from template Phelony Word 1 10-18-2011 03:28 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:07 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft