Thread: remain english words only
View Single Post
 
Old 05-09-2013, 02:21 AM
OTPM OTPM is offline Windows 7 32bit Office 2010 32bit
Expert
  
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default
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
Reply With Quote