Inconsistant Data Cleaning

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

This is a two part questions 1 is ther a way to look for data using wild
cards specifically when using the =IF function for example company names
sometimes read

ABC Co.
ABC Company
ABcharles Co

Is there a way to use =If with just the first few characters?

Furthermore can you get Excel to Remove unwanted data
For example

CELL A1 Contains: Q4 report number 43228
CELL B1 Desired Data: 43228
 
=LEFT(A1,2)="AB"

=--MID(A1,FIND("[",SUBSTITUTE(A1," ","[",LEN(A1)-LEN(SUBSTITUTE(A1,"
",""))))+1,LEN(A1))
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

text to columns with inconsistent data alignment 1
Text to columns 2
data splitting 1
Lookup to create List 3
Lookup to create a table of data in terms of selection 1
Summary data 2
Reference Formula 1
is this filter possible? 1

Back
Top