Results 1 to 3 of 3

need help Revealing control characters (RS, LF, US etc)

Threaded View

  1. #1
    Registered User
    Join Date
    06-18-2013
    Location
    canada
    MS-Off Ver
    Excel 365 (Mac)
    Posts
    26

    need help Revealing control characters (RS, LF, US etc)

    i have people copy and pasting cell from Excel into an ERP system and hidden characters that cause errors are migrading over, all the while remaining invisible until i copy into notepad++

    so basically any hidden value or character must show

    i would like to have these characters visible right in Excel so i can easily remove them.

    please help!

    thanks

    NC
    Last edited by nate02167; 03-25-2014 at 12:44 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Control the maximum of characters in a textBox
    By Mimouscha in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-26-2013, 07:10 PM
  2. Remove control characters in the cells
    By ramsdesk in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-25-2012, 06:28 PM
  3. How to remove Control characters in a cell ?
    By blackmagickar in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 03-13-2012, 03:02 AM
  4. Replies: 0
    Last Post: 04-07-2006, 11:25 AM
  5. Revealing UserForm Control Values with MouseOver
    By MWE in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-20-2005, 11:55 AM

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