DataPedia
  • DataPedia - Home
  • Who we are
  • Business Management System
    • DataPedia - Business Management System
    • BAS
    • Mobile Business
    • Book a demo
  • Excel Consulting
    • Ask Us Any Excel Question
    • Excel Tips and Tricks for beginners
  • Contact Us

Stripping Out Unwanted Characters - Excel Basics

12/12/2015

0 Comments

 

The raw file has characters that need to be removed...

Picture
Sometimes when you run an extract, the file contains data characters that you don't want in your file list.

These could be commas, dashes, stars or any weird character that is added with source files.   Want to strip this out quickly?  Here is a formula that can help.

Note - there is an easier way to do this using "text to columns" - but lets keep it interesting and use just formula.


Read More
0 Comments

VLookup in Excel - The basics...

3/11/2013

0 Comments

 

Our first sheet

Picture
Scenario
So you have a list of names in one column of a workbook - and you want to work out if they are attending a special event that is coming up.

Column A - has the list of names we are looking at (This is our Master List)

Column B - needs to be filled out with either a "Yes" or a "No" using our look-up from another list.

Problem:
The information we want is actually on another Excel sheet - lets take a look at what this 'Other' sheet looks like...


Read More
0 Comments

    Author

    Abe Dahbache has been working with EXCEL for over 15 years. He is a Microsoft Office User Specialist and has been developing solutions in Excel for some of the worlds largest companies.

    Archives

    December 2015
    November 2013

    Categories

    All
    Basic Vlookup
    Cleanse
    Concatenate
    Data Cleanse
    Data Strip
    Excel
    Lookup
    Reference
    Values
    Vlookup

    RSS Feed

Powered by Create your own unique website with customizable templates.
  • DataPedia - Home
  • Who we are
  • Business Management System
    • DataPedia - Business Management System
    • BAS
    • Mobile Business
    • Book a demo
  • Excel Consulting
    • Ask Us Any Excel Question
    • Excel Tips and Tricks for beginners
  • Contact Us