+ Reply to Thread
Results 1 to 2 of 2

Junk values in output.

  1. #1
    Registered User
    Join Date
    10-01-2014
    Location
    Delhi, india
    MS-Off Ver
    windows 7
    Posts
    11

    Junk values in output.

    Hi team,

    need your help to remove the junk values likes alphabet or any special symbol from the excel by any formula you can suggest.

    thanks

  2. #2
    Forum Contributor
    Join Date
    08-04-2014
    Location
    Riga
    MS-Off Ver
    2010
    Posts
    579

    Re: Junk values in output.

    Have you tried the TRIM formula? Also LEFT, MID, RIGHT could be useful for pulling fragments of data from a cell.

+ 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. Identify junk characters in a excel
    By vaishalis in forum Excel General
    Replies: 8
    Last Post: 08-12-2013, 02:23 PM
  2. Junk coding from TEXT import
    By penfold1992 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-30-2012, 06:24 AM
  3. Replies: 3
    Last Post: 04-08-2010, 08:50 AM
  4. Zero in the cell instead of some junk date
    By sunita_shaw in forum Excel General
    Replies: 2
    Last Post: 03-08-2006, 06:19 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