I have a spreadsheet (Excel from office 2003) with 45 years of results of a competition (and wish to continue using the spreadsheet for future years).
The spreadsheet has currently about 1000 names (e.g. P.J.Proby) and I use the spell check facility with a custom dictionary to check the names. This all works fine (except the suggested alternatives are not great) until I get to names like 'N.M.Parker-Tomlinson' or 'Sir Reginald Flintstone' because the spell checker considers these as separate words N.M.Parker; Tomlinson; Sir; Reginald; and Flintstone.
Is there some other non-printing character I can use to separate the words that will cause the spell checker to treat them are one word or some other way round the problem?
TFAI
PS Even if "" round the name would work its not really a solution since it will be tedious to type and look horrid on printing
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Yes indeed and that is what I do with 80% of the names. But I want to spell check as a single word names like
Sir Reginald Bosanquet (considrered as 3 words)
W.Sopwith-Camel (considered as 2 wrods)
and the spell checker considers these as more than one word
I really need something like a non-breaking space so that it looks like a space but the spell checker thinks its all one word.
Hi Rincewindwizz:
If you think the format W.Sopwith-Camel sounds ok, why don't you try with W.Sopwith_Camel ? It will consider "W.Sopwith_Camel" as a single word.
I'll find out whether there are special character/s available to be used to separate the words , still the spell checker to treat them are one word
Please go through below article.
http://office.micr
Refer ASCII non-printing control characters section
It describes all the non printable ascii characters.
My Suggestion:
Use an appropriate ascii value (Ex: horizontal tab, etc:) into your name.
refer the Insert an ASCII character into a document section for insert these character. Keep in mind that you have to press alt, then use keypad numbers to insert these chars.
This should make the separation you need and these should not be print in the document as well.
Hope this helps.
"-" is valid only because some people have hyphenated names. Underscore is not acceptable unless it can be made not to print.. I have tried the other non-printing characters (000 to 0032) but they all seem to act as a word delimiter.
Now, if I could ensure that the _ character was, for example, white (so it dod not show up while printing, that would be fine. but can you chance the color of a single character in a string in Excel?
And then I doscovered the offering below at http://www.mrexcel.com/for
Thanks for the _ suggestion.
Business Accounts
Answer for Membership
by: FlysterPosted on 2009-10-16 at 17:56:32ID: 25594359
Go to Tools Options Spelling & Grammar and select Custom Dictionaries - Modify. In the Word: box, enter the name as you want it, i.e. N.M.Parker and select add. Now, if you type N.N.Parker, it will show up in spell check.
Flyster