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
|