Inconsistant Data Cleaning

G

gallegos1580

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
 
K

Ken Wright

=LEFT(A1,2)="AB"

=--MID(A1,FIND("[",SUBSTITUTE(A1," ","[",LEN(A1)-LEN(SUBSTITUTE(A1,"
",""))))+1,LEN(A1))
 
Top