RE: Clean up your data with this easy-to-use Excel function
Thanks. It finally worked. Took a few times thinking I got it, but failed every time. Did not give up. finally figure out that the picture you got is what's needed, not to enter the cell numbers in the formula and definitely do not enter cell number of the 1st line that includes the field name/title bar of the column. Once I picked ONLY the cell A2 (literally), and followed your instructions, all was well. Hours saved on a job. Corrections do need to be reviewed since LLC might come out Llc or some names might come out looking wrong, but reviewing and fixing for a few minutes using this formula avoided many misspellings that would have occurred in retyping the whole database names, and saved us several hours of work. Thank you!
Keep Up with TechRepublic