Forum Home
Press F1
 
Thread ID: 142584 2016-07-29 13:23:00 Hard spaces in Excel Robin S_ (86) Press F1
Post ID Timestamp Content User
1423835 2016-07-29 13:23:00 Is it possible to enter 'hard spaces' (like those in Word) in cells in Excel?

TIA
Robin S_ (86)
1423836 2016-07-31 04:45:00 Is it possible to enter 'hard spaces' (like those in Word) in cells in Excel? TIA
Can you elaborate on what you are tying to achieve in Excel? Samples....
coldot (6847)
1423837 2016-07-31 07:22:00 Have a look at the post by RagDyeR put-a-hard-space-into-text-in-a-excel (www.pcreview.co.uk). Is this what you are after ? wainuitech (129)
1423838 2016-07-31 13:01:00 Thanks for the replies. Special thanks to Wainui and RagDyeR (if you're still calling) - that was just what I wanted. I had done a search but didn't come up with this one. Robin S_ (86)
1423839 2016-08-04 08:21:00 Yeah, I want to say thanks for this as well.

Up to know I was unaware of 'non-breaking spaces', but used the Alt 0160 today and it worked a treat.

We've got an app at work which inappropriately strips spaces out of names, so James John would get altered to Jamesjohn, or Van Dyke to Vandyke, or Te Puna to Tepuna. The space issue now lets me correctly add spaces between names. The app still munts the capitalisation, but at least I've now got a bit more control.
Paul.Cov (425)
1