| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for Displaying the First Character of a word
Is there a formula (or macros) that grabs the first character of a string of
text?? For example I have the following columns: Column A (Last name) Smith, Column B (First name) Heather. In column C i want the first Character of Column B so in this case it would be H. Any suggestions? Thanks in advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match then lookup | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| need formula to search column for a word and return another word | Excel Discussion (Misc queries) | |||
| in an excel macro can you import data from word into a cell? | Excel Discussion (Misc queries) | |||
| would like to know the formula amount and display word | Excel Discussion (Misc queries) | |||
Threaded Mode
