Excel + Google Sheets · AI prompt
Initials from any name, written by AI
First letter, plus the letter right after the space.
The formula
=LEFT(A2, 1) & MID(A2, FIND(" ", A2) + 1, 1)What each part means
LEFT(A2, 1)First letterFIND(" ", A2) + 1Position after the spaceMID(..., 1)That letter
Example
| A | B | |
|---|---|---|
| 1 | Name | Initials |
| 2 | Laura Gómez | |
| 3 | João Silva | |
| 4 | Priya Shah | |
| 5 | Tom Baker |
| A | B | |
|---|---|---|
| 1 | Name | Initials |
| 2 | Laura Gómez | LG |
| 3 | João Silva | JS |
| 4 | Priya Shah | PS |
| 5 | Tom Baker | TB |
Step by step
- Open ChatGPT, Gemini or Copilot.
- Describe your columns and what you want, in your own words.
- Paste the formula it gives you in cell B2:
=LEFT(A2, 1) & MID(A2, FIND(" ", A2) + 1, 1) - Press Enter and drag it down.
Where it works
- Every version of Excel
- Google Sheets
- Excel for the web (free)
The same formula in other languages
- English AI prompt
- Español Prompt de IA
- Português Prompt de IA