Results 1 to 4 of 4

Mutiple languages in cells

Threaded View

uk17340 Mutiple languages in cells 03-26-2014, 05:24 PM
Marc L Try this ! 03-26-2014, 08:41 PM
Marc L Mod to delete numbers in... 03-26-2014, 09:01 PM
uk17340 Re: Mod to delete numbers in... 03-27-2014, 03:37 AM
  1. #1
    Registered User
    Join Date
    07-07-2013
    Location
    uk
    MS-Off Ver
    Office 2010
    Posts
    8

    Mutiple languages in cells

    I have some excel documents at work that were originally in Japanese but have been translated into English.
    Majority of the cells in the worksheet have one line of English with a line of Japanese after it.
    Is there any way the Japanese characters can be removed leaving only the English phrase in the cell.
    There are some cells that also contain numbers and I would like to remove only the figure next to the Japanese text.

    I've attached an example

    Thanks in advance
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. VBA to filter "(Blank)" cells in pivot table , but in foreign languages too.
    By MarMo in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-07-2013, 11:27 AM
  2. Conditional formating, mutiple variables, mutiple sheets
    By Adam_D in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-11-2012, 06:47 AM
  3. Replies: 0
    Last Post: 01-06-2012, 07:09 AM
  4. how to add mutiple cells and columns
    By wakeandbake in forum Excel General
    Replies: 3
    Last Post: 05-11-2011, 07:25 PM
  5. mutiple cells need $
    By blackstar in forum Excel General
    Replies: 4
    Last Post: 02-25-2007, 08:12 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1