Removing Chinese Characters from a spreadsheet

[heyjay]

Hi all-
I'm fairly new to using excel, and I have a spreadsheet that has data in both English and Chinese, essentially the same data twice in each cell, once in each language.

I'm trying to figure out how to remove all the Chinese characters, and could use some tips. If it helps, each cell has the English version first, folllwed by the Chinese translation.

Thanks!

[kayelindra]

I SO don't know much about Excel, but I know under data you can choose "text to columns" and set the separator to whatever you want to to be. You can set "comma" as your separator and it will wind up giving you multiple columns of data..if your English verison is more than a word or two long it wouldn't be worth the effort, though.

[oldchippy]

Hello there,

It would be better if you could provide a small zipped sample of your data.

To post a zipped example, go to “My Documents” or wherever you have your file stored, right-click and “Send to > Compressed file”, then attach this zipped file to your post.

[heyjay]

Hey, you guys are fast

I can't post the exact stuff I'm working with since it's proprietary, but here's a simple one-cell example. The actual document is just like this, but thousands of columns long.

Thanks again.

[oldchippy]

Assumming it's exactly like your sample with English on top and Chinese below, try this

=LEFT(A1,FIND(CHAR(10),A1,1)-1)