Hi,

Add another header column and enter this function in the row cell

Joins several text strings into one text string.

Syntax

CONCATENATE (text1,text2,...)

Text1, text2, ... are 1 to 30 text items to be joined into a single text
item. The text items can be text strings, numbers, or single-cell references.

Remarks

You can also use the ampersand (&) calculation operator instead of the
CONCATENATE function to join text items. For example, =A1&B1 returns the same
value as =CONCATENATE(A1,B1).

Challa Prabhu

"Shamu" wrote:

How can i extract full name to Last Name, First Name, Middle Name

Full Name format: Canas Fernando De Paz

Extracted Format:
LN: Canas
FN: Fernando
MN: De Paz