I copied and pasted some data from MS Word in to an existing sheet but the find function won't detect some of the new entries.
Any help would be greatly appreciated.
I copied and pasted some data from MS Word in to an existing sheet but the find function won't detect some of the new entries.
Any help would be greatly appreciated.
bit hard to guess ,have you tried SEARCH instead
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Thanks for the response.
I don't know what you mean by SEARCH.
Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
I've attached a sample from WORD and one from Excel.
Last edited by ph1l; 02-09-2013 at 05:15 AM.
oh no you havent,and when you say find do you mean find/replace or the excel function =find()
and what entries wont it find?
I thought I'd attached the files but after submitting the post they weren't there. So I've tried again.
Yes, I mean find/replace.
I pasted an entry "I Couldn't Live Without Your Love"(amongst others) from Word but Excel won't detect it unless I retype the entry while in Excel.
well that don't help
in the excel workbook you have attached what exactly cannot be found by find?
I'm making a worksheet of song titles, artists and album titles of my cd collection. I decided Excel would be a better way of saving the data than WORD. When I copy and paste a list of song titles from WORD into Excel, the find/replace function doesn't locate some of the new entries. Most notably songs titles beginning with I.
Hope this helps explain the situation better.
I think Martin's point is, if you show the data, then highlight the problem areas, and have a note explaining what it is your trying to do, (ie- "I am tryind to replace "this" with "that"), then it would be easier to help you..so far we have some data, a vague definition of the problem, and no idea of what you expect to see...
A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
-Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
-To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
If you received helpful response, please remember to hit the * of that post
I've supplied the error message from the worksheet. I hope this helps.
how can we search images to try and replicate the result?
but
1. make sure the Match entire cell contents is not selected in options
2. you could try in find *i'm stoned*
Last edited by martindwilson; 02-10-2013 at 05:59 AM.
Match entire cell contents was unchecked and adding the *'s made no difference.
Out of the list I attached, the entries in red aren't detectable by the find function.
I Can’t Help Myself (Sugar Pie, Honey Bunch)
I Couldn’t Live Without Your Love
I Feel The Earth Move
If I Only Had Time
I Got The Music In Me
I Like How It Feels
I Love Rock ‘n’ Roll
I’m Stone In Love With You
In The Country
In The Mood
Isn’t She Lovely?
It’s Too Late
I have discovered if I search without using the first word, ie: "stone in love" rather than "i'm stone in love", it detects it.
Not a solution but a workaround.
More Today Than Yesterday
Baby It's You
Smile A Little Smile For Me
Cherry Hill Park
Na Na Hey Hey Kiss Him Goodbye
Venus
Early In The Morning
Arizona
The Rapper
Come Saturday Morning
Tracy
Mississippi Queen
is the attached list none of the above are in it!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks