+ Reply to Thread
Results 1 to 3 of 3

Data Cleaning Exercise

Hybrid View

loganc123 Data Cleaning Exercise 04-26-2016, 06:17 PM
Norie Re: Data Cleaning Exercise 04-26-2016, 06:24 PM
loganc123 Re: Data Cleaning Exercise 04-26-2016, 06:27 PM
  1. #1
    Registered User
    Join Date
    02-02-2016
    Location
    Orono, ME
    MS-Off Ver
    2013
    Posts
    21

    Data Cleaning Exercise

    Hello, I am trying to learn how to clean up a data set of emails.
    A lot of the tasks I have done successfully, but the task of checking if the starting character is NOT an "." or an "@" is tripping me up.

    =IF(LEFT(B2,1)=".",FALSE,TRUE)
    Checks if it starts with a period, and works, but how can i incorporate the "@" into there.
    I have a feeling an OR statement has to go somewhere, but everywhere I tried, it didn't work.

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,645

    Re: Data Cleaning Exercise

    Perhaps.

    Formula: copy to clipboard
    =OR(LEFT(B2,1)={".","@"})
    If posting code please use code tags, see here.

  3. #3
    Registered User
    Join Date
    02-02-2016
    Location
    Orono, ME
    MS-Off Ver
    2013
    Posts
    21

    Re: Data Cleaning Exercise

    Awesome, Thanks a lot Norie! +1

+ 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. cleaning DATA
    By OSK in forum Excel General
    Replies: 1
    Last Post: 10-30-2014, 09:51 AM
  2. Data cleaning
    By platesigns in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-13-2014, 12:59 PM
  3. [SOLVED] Data Extraction Exercise
    By JakeMann in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 10-04-2012, 11:16 AM
  4. Help cleaning up data
    By Impartial Derivative in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-12-2011, 01:26 PM
  5. Columbia student exercise, Monthly > Quarterly data by Macro exercise
    By alepenn in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-18-2011, 12:04 AM
  6. #NA, cleaning data!
    By thardy in forum Excel General
    Replies: 7
    Last Post: 02-26-2007, 06:39 PM
  7. Data Cleaning
    By mazmjh in forum Excel General
    Replies: 1
    Last Post: 11-27-2006, 12:12 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