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

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