Lista De 100 Nombres Y Apellidos En Que Excel May 2026

To create or find a list of 100 names and surnames in Excel, you can use official data from sources like the Instituto Nacional de Estadística (INE) or generate them automatically using formulas. INE. Instituto Nacional de Estadística Common Names for Excel (Spain & Latin America)

If you need sample data, these are some of the most frequent names and surnames often used in professional spreadsheets: Top First Names

: Antonio, Jose, Juan, Manuel, Francisco, Maria Carmen, Ana, Isabel, Maria, and Dolores. Top Surnames

: Garcia, Rodriguez, Gonzalez, Fernandez, Lopez, Martinez, Sanchez, Perez, Gomez, and Martin. INE. Instituto Nacional de Estadística How to Generate 100 Random Names

Instead of typing each one, you can create a dynamic list in seconds: Preparation

: Create two columns: one with common first names (e.g., 20 names) and one with common surnames (e.g., 20 surnames).

: Use the following formula in a new cell to pick one from each list randomly: lista de 100 nombres y apellidos en que excel

=INDEX(NamesRange, RANDBETWEEN(1, 20)) & " " & INDEX(SurnamesRange, RANDBETWEEN(1, 20))

: Drag the formula down to the 100th row to complete your list. Essential Excel Tools for Name Lists

Once you have your 100 names, these features help you manage them: Flash Fill

: Use this to quickly separate "Name Surname" into two different columns. Just type the first name in the next cell and press Text to Columns : If your list is in one cell, go to Data > Text to Columns and select "Space" as the delimiter to split them. Unique Function =UNIQUE(Range)

to instantly remove any accidental duplicates from your 100 entries. Custom Lists : You can save your 100 names as a custom list

If you have a separate list of first names (Col E) and surnames (Col F), you can generate a random pair using these formulas: To create or find a list of 100

Generate Random Full Name: Use =INDEX($E$2:$E$21, RANDBETWEEN(1, 20)) & " " & INDEX($F$2:$F$21, RANDBETWEEN(1, 20)).

Automated Numbering: In cell A2, type =SEQUENCE(100) to instantly create a list from 1 to 100. 2. Quick Management Features

Once you have your list, use these features to keep it organized:

Data Validation: Create a dropdown menu to select names from your list without typing.

Remove Duplicates: Use the UNIQUE function to ensure no names repeat in your dataset.

Split Text to Columns: If names and surnames are in one cell, go to Data > Text to Columns and use "Space" as a delimiter to separate them into individual columns. A structured data table (100 rows) with realistic

Combine Columns: Use the CONCAT function or the & operator (e.g., =A2 & " " & B2) to merge names and surnames into a single cell. 3. Sorting and Organizing

I will provide:

  1. A structured data table (100 rows) with realistic Spanish names (first names) and Spanish surnames (last names).
  2. Instructions on how to paste it into Excel and use additional features (randomization, splitting, concatenation).

Paso 2: Fórmula para generar nombres completos

En la celda A1 de tu hoja principal, escribe la siguiente fórmula:

=ÍNDICE(Hoja2!$A$1:$A$20; ALEATORIO.ENTRE(1;20)) & " " & ÍNDICE(Hoja2!$B$1:$B$20; ALEATORIO.ENTRE(1;20)) & " " & ÍNDICE(Hoja2!$B$1:$B$20; ALEATORIO.ENTRE(1;20))

Explicación: Esta fórmula escoge un nombre aleatorio de la lista A y dos apellidos aleatorios de la lista B (simulando el apellido paterno y materno).

Method 1: Download a Pre-Made List (Easiest)

The fastest way is to use Excel's built-in data types:

  1. In cell A1, type First Name. In B1, type Last Name.
  2. Select column A, go to the Data tab > Data Types group > Geography.
  3. Click the add field button (the small icon) and select "First name." Repeat for "Last name" in column B.
  4. Excel will generate random common names – just drag down to fill 100 rows.

Alternatively, you can copy free public datasets from GitHub (e.g., "random-names-dataset") or use Excel's RANDBETWEEN function with a hidden list of real names (see Method 3).

Trucos profesionales para manejar tu lista de 100 nombres y apellidos en Excel

Una vez que tienes tu lista, aquí hay 5 cosas que puedes hacer:

Método 2: Generar automáticamente una lista de 100 nombres y apellidos con fórmulas

Si no quieres copiar manualmente, Excel te permite crear aleatoriamente esta lista usando dos funciones: ALEATORIO.ENTRE combinada con ÍNDICE.