+ Reply to Thread
Results 1 to 3 of 3

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

Hybrid View

nate02167 need help Revealing control... 03-25-2014, 12:27 PM
ragulduy Re: need help Revealing... 03-25-2014, 12:54 PM
nate02167 Re: need help Revealing... 03-25-2014, 01:01 PM
  1. 03-25-2014, 12:27 PM #1
    nate02167 is offline
    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.
    Reply With QuoteRegister To Reply
  2. 03-25-2014, 12:54 PM #2
    ragulduy is offline
    Forum Expert
    Join Date
    04-22-2013
    Location
    .
    MS-Off Ver
    .
    Posts
    4,418

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

    http://answers.microsoft.com/en-us/o...8-3c09a050c1d1
    Reply With QuoteRegister To Reply
  3. 03-25-2014, 01:01 PM #3
    nate02167 is offline
    Registered User
    Join Date
    06-18-2013
    Location
    canada
    MS-Off Ver
    Excel 365 (Mac)
    Posts
    26

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

    theres no option for show control characters... in 2010 or 2013 excel

    could you send me a screenshot? maybe i cant see it
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

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. How can I control the length of characters a code will return?
    By Tayo in forum Excel General
    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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1