Instances of DBA

[Welsh Mark3]

Is there a formula that can give me the string of text after an intsance of DBA.

Assuming the original text is in Column A

[TABLE="width: 500"]
<tbody>[TR]
[TD]Original Text[/TD]
[TD]Desired Result[/TD]
[/TR]
[TR]
[TD]Elite Southern Construction LLC dba Master Roofing[/TD]
[TD]Master Roofing[/TD]
[/TR]
[TR]
[TD]Riland Richardson, Inc. Dba C & R Trucking[/TD]
[TD]C & R Trucking[/TD]
[/TR]
</tbody>[/TABLE]

 

[mumps]

Assuming your data is in column A starting at row 2, place this formula in cell B2 and copy it down as far as there is data in column A.
=RIGHT(A2,LEN(A2)-SEARCH("DBA",A2,1)-3)

 

[Nine Zero]

This will take care of any case regardless if uppercase, lowercase, or camelcase and will trim the space after DBA which can help when you have something like "DBAC & R Trucking" when someone forgets the space

=TRIM(RIGHT(A2,LEN(A2)-SEARCH("dba",A2)-2))


EDIT: Ahh someone beat me to it lol, now you have two options

 

[jtakw]

Hi,

Another way:

Book1
	A	B
1	Original Text	Desired Result
2	Elite Southern Construction LLC dba Master Roofing	Master Roofing
3	Riland Richardson, Inc. Dba C & R Trucking	C & R Trucking
Sheet271

Cell Formulas
Range	Formula
B2	=MID(A2,SEARCH("Dba",A2)+4,255)

Formula copied down.