0
To find the first letter of a single name is easy. You can get the first letter starting at the left of the text. If the name was in cell B3 then your formula, which can be any cell except B3, would be:
=Left(B3,1)
If it is multiple names, then that is more complicated because of the way names can be structured, like finding where in the cell the second name begins and the fact that names can be double-barrelled. It is impossible to teach a computer to differentiate between these names, because for example, some names can be both a first name or a surname.
The best thing to do if you want to get initials from a first name and a surname is to put the parts of the name into different cells and use the previous function on each of these and put a full stop and a space between them. So if the firstname was in B3 and the surname in C3 then the formula in another cell would be:
=Left(B3,1)&". "&Left(C3,1)
Wiki User
∙ 14y ago
Add your answer:
Earn +20 pts
What is Dr Naismith's real name?
It is James Naismith but he later adopted the initail "A" for his middle name. So it is James A.Naismith
What is initail temperature?
cookies
How do you extract a data in Microsoft Excel?
Not sure if you want to know how to export data from Excel or import data into Excel. Either way, the answer depends on what you are trying to do. You can export data from Excel by using the SaveAs option to save the file in a format you choose. If you are trying to use another program to extract data from Excel, you will need to use the options available to that specific program.
How do you easily create Excel files in c?
You might be able to use C to extract data from an Excel file, but there is no easy way to write a program to create an Excel file.
The advantages and disadvantages of using Microsoft Excel Cube Function to extract data from a database?
None
What is an initail?
Initial means first of something. For example when people ask you what your initials are you will tell them the first letter of your first, middle and last name.
What is the use of name menu in Microsoft Excel?
I am not aware of a name menu in Excel. However, Excel has a name box that displays the name or cell reference of the active cell.
What is the worksheet location where Excel copies records that meet comparison criteria is called?
It is the "Copy to" area or the extract range.
What is another name for lists on Excel?
Ms excel
What is the generic name for Excel?
Microsoft Excel is a spreadsheet.
What is the extention name fot Excel?
XLS is the main extension name used in Excel.
What is the birth name of Maeva Excel?
Maeva Excel's birth name is Anicia Greck.
