Removing Unneeded Characters from Cells

[carrieebacon]

For some reason when I import csv files that have been exported from Civil 3D they contain characters that are not needed. For example, the letter P is in front of the text in each cell or by itself in a cell. In column D, each cell contains a structure ID such as CI #145. Instead, it says C4;CI #145}. Is there any way for me to do a mass clean up to get rid of what I don't need?

 

[Joe4]

OK, would it be possible for you to just copy/paste the data from your text file (like you posted in post 8) as straight data, and not an image, so we have a working data file we can copy from?
We cannot copy/convert data from an image into workable data.

 

[Joe4]

Do you not need this anymore?