Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-08-2017, 01:30 PM
sivartnosredna7 sivartnosredna7 is offline Can I remove spaces between only Chinese characters? Windows 8 Can I remove spaces between only Chinese characters? Office 2010 64bit
Novice
Can I remove spaces between only Chinese characters?
 
Join Date: Jan 2017
Posts: 2
sivartnosredna7 is on a distinguished road
Default Can I remove spaces between only Chinese characters?

I working with several massive bilingual texts in English and Traditional Chinese, but the Chinese characters have spaces between them...here's a small sample:



"The Yin institutions were, under the Chou, more or less continued by the feudal state of Sung 宋. In the Tso chuan, Ch'êng 15 (Tso chuan chu shu, 27.26a-b; L. 388), where the officers of Sung are described, the following names are enumerated: yu-shih 右 師, tso-shih 左 師, ssŭ-ma司 馬, ssŭ-t'u 司 徒, ssŭ-ch'êng司 城, ta-ssŭ-k'ou 大 司 寇, hsiao-ssŭ-k'ou 小 司 寇, ta-tsai 大 宰, and hsiao-tsai 小 宰."

This makes it very hard to search for Chinese characters in the text, which is the primary reason I'm collecting them. Is there anyway to find and replace ONLY those spaces in between the Chinese characters?

I know that I can use [⺀-■]{1,} [⺀-■]{1,} with wildcards to find spaces between Chinese characters, but we're talking about thousands of cases of this and I'm wondering if I can somehow use Find and Replace to do this all at once.

Thank you in advance for any help you might be able to provide.
Reply With Quote
  #2  
Old 01-08-2017, 04:48 PM
macropod's Avatar
macropod macropod is offline Can I remove spaces between only Chinese characters? Windows 7 64bit Can I remove spaces between only Chinese characters? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Assuming your wildcard Find expression is correct, you should be able to use:
Find = ([⺀-■]) ([⺀-■])
Replace = \1\2
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 01-09-2017, 05:33 AM
sivartnosredna7 sivartnosredna7 is offline Can I remove spaces between only Chinese characters? Windows 8 Can I remove spaces between only Chinese characters? Office 2010 64bit
Novice
Can I remove spaces between only Chinese characters?
 
Join Date: Jan 2017
Posts: 2
sivartnosredna7 is on a distinguished road
Default Thank you!

I tried to figure it out for a while before I asked for help. It worked perfectly, thank you very much
Reply With Quote
Reply

Tags
chinese, find & replace, wildcards

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to remove spaces from Cells which are at the end of value? LearnerExcel Excel 2 12-19-2016 01:10 PM
Can I remove spaces between only Chinese characters? How do I Remove A Specific Amount of Characters from Lines in a Document? tatihulot Word 5 01-22-2016 05:55 AM
Strange Characters appear when selecting SHOW ALL NON PRINTING CHARACTERS ann Amber Word 1 08-01-2015 08:06 PM
editing text and remove spaces romanticbiro Word VBA 5 07-04-2014 07:42 PM
How to remove these unknown characters appearing rajpes Word 1 03-02-2012 03:24 AM

Other Forums: Access Forums

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


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