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: | 415 |
Nodes: | 16 (2 / 14) |
Uptime: | 34:59:37 |
Calls: | 8,720 |
Calls today: | 3 |
Files: | 13,276 |
Messages: | 5,956,170 |