You can apply autofilters to the columns and carefully note the range
of values that you can see in the pull-down list for each filter - you
might see "Dollar xxx", " Dollar xxx", " Dollar xxx", so this will
give you some idea of what you have to change.

You can then highlight all the cells in your six columns and use Find &
Replace (CTRL_H) repeatedly to ensure you have the same naming
convention - shouldn't take too long. For example:

Find: " D" (space space D)
Replace with: "D"

Find: " D" (space D)
Replace with: "D"

Find: " U"
Replace with: "U"

Find: "$"
Replace with: "Dollar " (Dollar space

Find: " " (2 spaces)
Replace with: " " (single space)

Obviously, you don't include the quotes above when you type the entries
in. You can then use the filters again to see if you have missed any
different formats.

Hope this helps.

Pete