+ Reply to Thread
Results 1 to 6 of 6

characters outside of columns that should not be there

Hybrid View

  1. #1
    Registered User
    Join Date
    03-03-2019
    Location
    Anaheim, California
    MS-Off Ver
    Office Plus 2016
    Posts
    41

    characters outside of columns that should not be there

    We need to upload an Excel file and we want to make sure there are no characters outside of A-Y and 2-3425

    I recall doing this before, but forgot. I know to highlight all the text we want to keep or upload... then... ???

  2. #2
    Forum Contributor noboffinme's Avatar
    Join Date
    08-29-2013
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2003/7/10/13/16/19
    Posts
    1,071

    Re: characters outside of columns that should not be there

    Hi try Shift + f8 to get the contiguous Cells.
    Remember you are unique, like everyone else

  3. #3
    Registered User
    Join Date
    03-03-2019
    Location
    Anaheim, California
    MS-Off Ver
    Office Plus 2016
    Posts
    41

    Re: characters outside of columns that should not be there

    I'm highligting all my text and clicking shift + F8 and nothing is happening

  4. #4
    Forum Contributor noboffinme's Avatar
    Join Date
    08-29-2013
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2003/7/10/13/16/19
    Posts
    1,071

    Re: characters outside of columns that should not be there

    Yes, that was to ensure you only selected the Cells you selected A-Y and 2-3425.
    So now what do you do to Upload this selection?
    Where/How are you uploading it?

  5. #5
    Registered User
    Join Date
    03-03-2019
    Location
    Anaheim, California
    MS-Off Ver
    Office Plus 2016
    Posts
    41

    Re: characters outside of columns that should not be there

    I don't want to upload it now. I want to execute it to see if there are any characters outside of my data. How?

  6. #6
    Forum Contributor noboffinme's Avatar
    Join Date
    08-29-2013
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2003/7/10/13/16/19
    Posts
    1,071

    Re: characters outside of columns that should not be there

    OK, that's an unusual question but if you want to see what, if any, data is in columns 'Z' and onwards eg: 'AA', 'AB', 'AC' etc, you could apply a filter on the top row & see if any values exist.
    Can you explain why there might be values beyond this Column?

+ 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. Extract words with same first 2 characters and put them in different columns
    By Niclal in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-07-2018, 05:06 AM
  2. [SOLVED] Text to Columns - 30,000 characters
    By igotgame in forum Excel General
    Replies: 1
    Last Post: 11-14-2017, 11:59 AM
  3. [SOLVED] Using vba to remove characters in columns
    By kieranbop in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-26-2012, 03:14 AM
  4. Compare characters in two columns
    By enhydra in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-03-2011, 11:22 AM
  5. Removing Characters from columns
    By ringrim in forum Excel General
    Replies: 5
    Last Post: 08-13-2008, 06:02 PM
  6. how to detect characters and add columns
    By pvboston in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-30-2007, 07:56 PM
  7. Replace characters in columns in excel
    By moonwalker in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-24-2006, 10:07 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