+ Reply to Thread
Results 1 to 3 of 3

remove all except a-z, korean characters and spaces

  1. #1
    Registered User
    Join Date
    05-12-2020
    Location
    manila, Philippines
    MS-Off Ver
    2019
    Posts
    1

    Question remove all except a-z, korean characters and spaces

    i want to remove all characters except a-z, spaces and korean characters

    Can someone please provide some suggestions. thank you.

    Before:
    1. to startled
    2.temperature
    3. to grow
    璉4,기타 재해
    璉5/기억하다
    璉6:기온이 낮다

    After:
    to startled
    temperature
    to grow
    기타 재해
    기억하다
    기온이 낮다
    Attached Files Attached Files
    Last edited by JossMedina; 05-12-2020 at 09:14 PM. Reason: Attach Sample

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,368

    Re: remove all except a-z, korean characters and spaces

    Welcome to the forum.

    This can be done easily with PowerQuery:

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: remove all except a-z, korean characters and spaces

    UDF
    Use in cell llike
    =AlphaK(A2)

    Please Login or Register  to view this content.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How to remove spaces between characters and numbers within cells in Excel?
    By Edgars.Aronietis in forum Excel General
    Replies: 8
    Last Post: 08-26-2015, 07:42 AM
  2. [SOLVED] Need to remove the first 2 characters in string plus spaces on the left with macro
    By abjac in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-15-2014, 06:11 AM
  3. remove spaces and characters in hyperlink - macro
    By missy22 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-05-2013, 09:23 AM
  4. Replies: 8
    Last Post: 12-17-2012, 05:30 AM
  5. [SOLVED] remove spaces (special characters) after numbers
    By fareastwarriors in forum Excel General
    Replies: 13
    Last Post: 11-04-2012, 09:25 PM
  6. [SOLVED] Remove All Text,Special Characters, & Spaces
    By g48dd in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 06-01-2011, 09:24 AM
  7. Replies: 4
    Last Post: 03-07-2008, 05:21 PM

Tags for this Thread

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