Text not found after pasting it with paste values

**warston** · 07-18-2013, 01:53 PM

Hi, I hope I have explained this so that it can be understood, I apologise if I have not.
I have paste some information from sheet 1 into sheet 2, columns B to Z (text in some columns numbers in others but no mixed cells), sheet 1 contained the formulas so I pasted it as 'paste values' into sheet 2, but although I can see the text, when I type a name into another cell to search for an item and return the vale in an adjacent cell, it will not find it. if I retype the name that was 'paste as value', it will recognise it. any ideas please.

Regards.

**Grimace** · 07-19-2013, 01:33 AM

this can often occur if there are spaces before / after the text.

Try either checking for spaces and deleting them, or adding a wildcard to your search (eg if searching for the word John, try John* or *John* in the search. This will return any values that START WITH John, or CONTAIN John respectively.

The hidden space is a searches arch enemy ;-)

**warston** · 07-19-2013, 06:10 AM

Thank you for your suggestion Grimace but sadly it did not work.
Regards.

Text not found after pasting it with paste values

LinkBack

Thread Tools

Rate This Thread

Display

Text not found after pasting it with paste values

Re: Text not found after pasting it with paste values

Re: Text not found after pasting it with paste values

Thread Information

Users Browsing this Thread

Similar Threads

If text if found, paste/copy into column C

[SOLVED] Outputting different values depending on which text value of multiple is found in a string

Check for data in cell. If found paste text into same row another column

Match mutliple values and then display text if found

Find text in another workbook and paste if found match - VBA

Bookmarks

Bookmarks

Posting Permissions