Inventory

Index

Filters

Proper

Paste Special

Find & Replace

Format Cells

Remove Leading 1

Remaining Phone  Issues

 

Fill In State

Text to Columns 1

Text to Columns 2

Concatenate

Trim

 

Text to Columns Fixed

Left