How to I tell excel not to recognize charcters that are not there.

B

bjwoodruff

A server feeds information into my workbook that is needed to find other
peices of information in other workbooks. The problem is that when the
names are inputed into the first book the names have extra charcters
that do not show up. They are blank. The reason why I want to get rid
of these is because that cells contents needs to be copied so it can be
searched in another book. These "ghost" charcters are comming up in the
search and will not find the items I need.
I hope I explained my problem correctly.

Benjamin Woodruff
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

excel does not recognize dates 2
in an Excel database, comparaison between two columns with "almost"the same names => how to search i 1
Excel VBA - macro that copies the sheets to another workbook 3
Excel 2013 vlookup to different workbooks not working 5
Combining Workbooks - Issue with Names 3
I refuse to recognize that there are impossibilities 55
Identify Duplicates that are not identical 4
"how to edit outlook address list" 2

Top