The first part, it is not difficult. You have all three names in one cell.
FIrst take the data from column B and move it to column D. Next select
column A and pull-down

Data Text to Columns... and use the space as the separator.

This will take the names from column A and split them into columns A, B, and
C.

Since the family name is alone in column A, you can use the VLOOKUP()
function to find it.

I don't know how to solve the problem of mis-spellings.
--
Gary''s Student


"filo666" wrote:

Hi, I have a program and I want my user be able to look up a famyli name
instead of the whole name, I mean:
A B
Vazques Mota Frnacisco 1
Barrios Medina Alejandro 2
Concepción Báustegui Antonio 3
Andres Gustamante Berenice 4
Medina Arroyos Fernando 5
............... ...
1. I want that the user put Vazques and returns the number 1 value
2. I think this question is a difficult one, but ¿What about if the user
made a mistake and instead of Vazques he puts Vasques, There could be somehow
the computer find the name???
TIA