Help fix Extra Spaces and other errors

[desibouy]

Hi,

So I've been working on like 20 different CSV files, these are all products we sell, the task was to find specifications for each product, the specifications columns could range from 3 to 20. Some CSV files contain 1500 products others 100, different CSV because of the different categories. Thinking around 7000 products if not more.

So now it's time to review these files looking for errors, spelling mistakes, and anything else.
Heres what I found below (few examples)

Incontinence Category - Full.csv
	AA
1	Size
2	x-Large
3	X-Large
4	X -Large
5	X-Large
Incontinence Category - Full

Row 4 being correct.

Incontinence Category - Full.csv
	AB
1	Waist/Hip Size
2	59"-64"
3	59" -64"
4	59" - 64"
Incontinence Category - Full

Row 3 being correct.

Incontinence Category - Full.csv
	AC
1	Weight
2	18 lbs.
3	18lbs
4	18 lb
5	18 lbs
Incontinence Category - Full

Row 4 being correct.

Incontinence Category - Full.csv
	AH
1	Backsheet
2	Cloth-Like
3	Cloth-like
4	Cloth-like
Incontinence Category - Full

Row 3 being correct.

Catagory file.xlsx
	B
14	Stethoscopes
15	Thermometers
16	Pulse Oximeters
Diagnostic Products

Leading and trailing spaces



Please can anyone help me with these errors? Not sure if you can get it to spell check them too.

Much appreciated & Thanks in advance.

 

[desibouy]

ok, what about forgetting the spell checking. Kinda old here but you can spell-check within Excel lol.

 

[Radoslaw Poprawski]

yes but this wont tell you if "-text" is correct or "- text" is correct