Please help - Filtering Data in Excel

[Stormseed]

try.htm
	E	F	G	H
7003	NoValue	DataBase	EAG	Active
7004	NoValue	Database	EAG	Active
7005	NoValue	Database	EAG	Active
7006	NoValue	Database	EAG	Active
7007	NoValue	DATABASE	E-Broking	Active
7008	NoValue	DATABASE	E-Broking	Active
7009	NoValue	DATABASE	E-Broking	Active
7010	NoValue	Database	EAG	Active
7011	NoValue	database		Active
7012	NoValue	DATABASE	E-Broking	Active
7013	NoValue	database	E-Broking	Active
7014	NoValue	database	E-Broking	Active
7015	NoValue	DATABASE	E-Broking	Active
7016	NoValue	database	E-Broking	Active
7017	NoValue	DATABASE	E-Broking	Active
7018	NoValue	Database,SelfGenerated	Commodity	Active
7019	NoValue	databas	E-Broking	Active
7020	NoValue	Database	(Franchisee)Commodity	Active
7021	NoValue	Database	(Franchisee)Commodity	Active
7022	NoValue	Databas	(Franchisee)Commodity	Active
7023	NoValue	Data	(Franchisee)Commodity	Active
7024	NoValue	Databse	(Franchisee)Commodity	Active
7025	NoValue	Database	(Franchisee)Commodity	Active
7026	NoValue	Database	(Franchisee)Commodity	Active
7027	NoValue	Database	(Franchisee)Commodity	Active
7028	NoValue	Datbse	Commodity	Active
7029	NoValue	Database	(Franchisee)Commodity	Active
7030	NoValue	Datbase	EAG	Active
7031	NoValue	Database	Commodity	Active
Sheet1

Dear all

I have come forward for some help from you experts out there...please shower it some !

It has been a hard time for to figure out this mess...I have learnt to attach the screen print from my PC on this board ! COOL !!

Ok...I have this huge data...the screenshot just a chunk of the same :wink: now...u would be able to view some data in column F -- the word frequently used there is "Database". Neverthless - this word "Database" is not proper by any means...case sensitivity or spelling. Now as far as my knowledge goes into Excel...I have tried using proper(), lower() and upper() to streamline this data column. However it does not serve the purpose I need to have something concrete wherein it would let me correct ALL THE MISPELLED WORDS with wrong spellings for "Database".

Hey...I do know we have exceptional experts on this board all willing to provide help and hence the reason I am here...please help me ! thanks so much in advance

 

[Peter_SSs]

Stormseed

Try this
1. Select column F by clicking its heading label.
2. Edit|Replace...|Find what: Dat*|Replace with: Database|Replace All

If this is not what you want, tell us in what way, and any further information you can.

 

[Stormseed]

Stormseed

Try this
1. Select column F by clicking its heading label.
2. Edit|Replace...|Find what: Dat*|Replace with: Database|Replace All

If this is not what you want, tell us in what way, and any further information you can.

Hey mate....thanks for the info...this would serve the purpose in only one way....as the screenprint I have shown has words which start with "Dat"...and I do have considerable sized data for which the starting letter of the word "Database" starts with different letters I dunno how am I going to do this...if manually then my life is on a toss...but I thank you from my heart for the idea you gave...it will help to unload some part of it !

I mean anything and everything which is possible please let me know that I can use to off load this burden...VBA, formulae, UDFs, etc anything !

 

[Peter_SSs]

as the screenprint I have shown has words which start with "Dat"...and I do have considerable sized data for which the starting letter of the word "Database" starts with different letters

If you just mean you have other data like, say, 'This Data Bse' and you also want it to be Database, then just change the Find what from Dat* to *Dat*

 

[Stormseed]

as the screenprint I have shown has words which start with "Dat"...and I do have considerable sized data for which the starting letter of the word "Database" starts with different letters

If you just mean you have other data like, say, 'This Data Bse' and you also want it to be Database, then just change the Find what from Dat* to *Dat*

Oh good lord...I just proved that I am bonehead! thanx pal...God Bless You !!