remain english words only

tomlam · #1 05-08-2013, 06:33 PM

Thanks Tony. Dear Sir/Madam

If we get the information as column A and D. How to find out their differernce (that is
find out the chinese words as results column F as attached files)

Tks
Tom

OTPM · #2 05-09-2013, 02:21 AM

Hi
Again assuming there are no spaces between the Chinese characters you could ue this formla (change the cell reference as needed):
=MID(A4,1,FIND(" ",A4))
Good luck.
Tony

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
object to remain in view	galgool	PowerPoint	2	01-19-2013 02:47 AM
Upgraded 2007 to 2010 - and bullet styles remain as 2007	m0912329	Word	3	06-23-2011 05:14 PM
Why Words doesn’t show the style of the selected words automatically????	Jamal NUMAN	Word	0	04-14-2011 03:20 PM
Translate from English to Spanish	marge0513	Word	1	05-30-2009 06:10 AM