Posted to microsoft.public.excel.worksheet.functions
|
|
How to use LEN & LEFT on last name to show only 3 letters
"M Kan" wrote:
How are the first and last names separated and do you have any 2-part last
names? Assuming they are in separate cells, the formula would look like this"
A1 = First Name
B1 = Last Name
=IF(LEN(B3)=2,LEFT(B1,3)&"Z",LEFT(B1,3))&LEFT(A1,1 )
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips
"Darlie Mary" wrote:
Need syntax to show first 3 letters of last name and first letter of first
name. Also if last name only has 2 letters, need to add a Z on end to make 3
letters.
The entire last name is in Column C and the first name is in Column A.
|