Help fix Extra Spaces and other errors

desibouy

Board Regular
Joined
Nov 20, 2014
Messages
98
Office Version
  1. 365
Platform
  1. Windows
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
1Size
2x-Large
3X-Large
4X -Large
5X-Large
Incontinence Category - Full

Row 4 being correct.

Incontinence Category - Full.csv
AB
1Waist/Hip Size
259"-64"
359" -64"
459" - 64"
Incontinence Category - Full

Row 3 being correct.

Incontinence Category - Full.csv
AC
1Weight
218 lbs.
318lbs
418 lb
518 lbs
Incontinence Category - Full

Row 4 being correct.


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

Row 3 being correct.


Catagory file.xlsx
B
14Stethoscopes
15Thermometers
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.
 
ok, what about forgetting the spell checking. Kinda old here but you can spell-check within Excel lol.
 
Upvote 0

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

Forum statistics

Threads
1,213,560
Messages
6,114,306
Members
448,564
Latest member
ED38

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top