How to Fix Misspelled Customer Names with Excel

[@bhavinsolanki1091]

fantastic. i was doing this for last 1-2 week thinking whether its a good practice or not, this video gave me positive feedback. thanks a lot.

[@DougHExcel]

Keep it up!

[@pipo441]

That's so interesting. Have to watch it again though.

[@DougHExcel]

Glad you thought so!

[@nboisen]

After creating the lookup table, an alternative to using lookup formulas would be to merge queries in Power Query. The advantage of using queries would be the ease of updating if more customer names are added.

[@DougHExcel]

Hi Neil Boisen Music, Thanks for the comment and adding to the thread!

[@toptechkit]

This is good and can work in some cases. How about where the order of the names is inter-changed. I mean- assuming you want the order to be first name then second name and some names start with the last name then first name.

[@DougHExcel]

That might mean either an additional lookup or a concat of the data

[@Weehawk]

Nice!

[@DougHExcel]

Hi Lachdanan, thanks for the comment!

[@StopDrinkingtheLeftsKoolaid]

Shortcuts: MOVING A ROW OR COLUMN : highlight the row you want to move hold down the shift key Click on the border of the call and drag the row or column to its new location that’s it. You will notice, as your dragging the BORDER of the row or column changes to indicate that you were moving the entire row or column. Also, instead of copy / paste, select the cell you want to copy Hold down the Cntrl key and drag it to its new location. This will leave the word or number in the cell and place a copy into the new cell To duplicate into several open BORDERING cells, highlight the cell you want to copy and drag the fill handle down or to the side.