| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Formula Help
Hi
I'm looking for a formula which will return the first letter of a word in its adjacent cell. For example: A1 contains John. B1 would return J. I've been tinkering with Chip Pearson's FirstNameLastName formulae but to no avail. Thanks in advance. Zorro |
|
#2
|
|||
|
|||
|
Hi
=LEFT(A1,1) -- Regards Frank Kabel Frankfurt, Germany Zorro wrote: Hi I'm looking for a formula which will return the first letter of a word in its adjacent cell. For example: A1 contains John. B1 would return J. I've been tinkering with Chip Pearson's FirstNameLastName formulae but to no avail. Thanks in advance. Zorro |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting an Excel formula to an Access query formula | Excel Discussion (Misc queries) | |||
| I want the results of a formula to show in cell, NOT THE FORMULA! | Excel Discussion (Misc queries) | |||
| What instead of an array formula part 2 | Excel Discussion (Misc queries) | |||
| Paste is is copying in formula, but display is wrong. | Excel Discussion (Misc queries) | |||
| Excel2K: Is it possible to use dynamic named ranges in custom data validation formula? | Excel Discussion (Misc queries) | |||
Linear Mode
