View Single Post
 
Old 05-08-2013, 02:09 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
Where you have entries that have no spaces between any of the Chinese characters you can use this formula in a blank column and copy it down the column:
=MID(A3,FIND(" ",A3),50)
Where you have variable numbers of spaces between any of the Chinese characters it becomes more difficult without knowing the maximum number of spaces involved.
Hope this helps.
Tony
Reply With Quote