Just use nested REPLACE() function:
replace(replace(replace(replace(replace(lower([Employer Name]), "inc",""), "-",""), "&",""), " co","")," llc","")
Subscribe to:
Post Comments (Atom)
-
It took me a while to figure out how to insert a space in Mathtype equations. This is especially useful when you write an equation with mult...
-
Recently I read post from Dr. Doug Hull's blog: http://blogs.mathworks.com/videos/2009/10/23/basics-volume-visualization-19-defining-s... -
To get the slope of a pair of x and y, usually I first plot the curve and then add the trend line. Actually there are two functions i...
Replacing multiple characters in a string is a fundamental task in programming. How Laptop Use It involves substituting specific characters with others, enhancing data processing and manipulation.
ReplyDelete