| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
leave only first letter of last name
I tried to search for this solution on the web, but finally gave up.
Here's what I want to do In a cell I have a users First and Lastname (yes both in the same cell). I'd like to end up with Firstname and first letter of Lastname (don't have to still be in a single cell, but would be nice). So go from: Ima User to Ima U Thanks for your help |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting Letter Grades to Numeric | Excel Worksheet Functions | |||
| How do I get a letter in one cell ito equal a number in anotherl.. | Excel Discussion (Misc queries) | |||
| Have A Letter Reference A Name For An Intoduction | New Users to Excel | |||
| Replace Letter "E" with Letter "C" for 200 Different Sums in a Col | Excel Worksheet Functions | |||
| Function / formula to be used if cell contains a letter. | Excel Worksheet Functions | |||
Threaded Mode
