I have a friend whose surname is "Alway". As I'm putting together a mailing list, I found myself typing that into Excel. It corrects it to "Always" -
Philip Herlihy wrote:
I have a friend whose surname is "Alway". As I'm putting together a mailing
list, I found myself typing that into Excel. It corrects it to "Always" -
What if you prefix with a single quote to make it a string literal e.g. 'Alway
In article <kcv33sFn7q3U1@mid.individual.net>, Andy Burns wrote...
Philip Herlihy wrote:
I have a friend whose surname is "Alway". As I'm putting together a mailing
list, I found myself typing that into Excel. It corrects it to "Always" -
What if you prefix with a single quote to make it a string literal e.g. 'Alway
Oddly, that seemed to work the first time I tried it, but subsequently didn't.
Can't explain that. The =LEFT() option did work, although it tried to correct
the string parameter (but accepted the edit).
Sysop: | Keyop |
---|---|
Location: | Huddersfield, West Yorkshire, UK |
Users: | 300 |
Nodes: | 16 (2 / 14) |
Uptime: | 48:16:11 |
Calls: | 6,710 |
Calls today: | 3 |
Files: | 12,243 |
Messages: | 5,354,638 |
Posted today: | 1 |