Dear Sir/Madam

Could u please help how to write a small macro programme to
change the column A to column D(in attachement named bcd excel file. That is only remain the english words( other chinese words, arrow.... will be delete automatically)



Thanks
Tom

Attached Files

bcd.xls (18.0 KB, 10 views)

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

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

Attached Files

bcde.xls (32.5 KB, 16 views)

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

Thanks Tony
my problems solved