AYUDA

%3CLINGO-SUB%20id%3D%22lingo-sub-2094139%22%20slang%3D%22es-ES%22%3EHelp%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2094139%22%20slang%3D%22es-ES%22%3E%3CP%3EHELLO%20I%20HAVE%20PROBLEM%20TO%20USE%20TWO%20COLUMNS%20AND%20CREATE%20A%20SINGLE%20.%20THE%20PROBLEM%20IS%20THAT%20I%20HAVE%20LAST%20NAME%20IN%20ONE%20COLUMN%20AND%20NAME%20IN%20ANOTHER%20I%20NEED%20TO%20HAVE%20THEM%20IN%20ONE%3C%2FP%3E%3CP%3EThanks%20a%20lot%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2094139%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2094210%22%20slang%3D%22en-US%22%3ERe%3A%20AYUDA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2094210%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F941775%22%20target%3D%22_blank%22%3E%40PAULAPERALS%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20use%20the%20function%20CONCATENATE%20or%20CONCAT%20or%20the%20symbol%20%26amp%3B%20as%20follows%2C%20assuming%20last%20name%20is%20in%20column%20A%2C%20first%20name%20in%20Column%20B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DCONCATENATE(A2%2C%22%2C%20%22%2CB2)%26nbsp%3B%26nbsp%3B%20will%20give%20you%20Aperals%2C%20Paul%3C%2FP%3E%3CP%3E%3DA2%26amp%3B%22%2C%20%22%26amp%3BB2%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20will%20give%20the%20same%20result%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20what%20it's%20worth%2C%20you're%20better%20off%20with%20two%20columns%20as%20your%20basic%20data%20base%2C%20because%20it%20gives%20you%20a%20lot%20more%20flexibility%20in%20the%20long%20run.%20With%20two%20columns%20you%20can%20assemble%20the%20output%20as%20%22Last%20Name%2C%20First%20Name%22%20or%20%22First%20Name%20Last%20Name%22%3B%26nbsp%3B%20you%20can%20also%20easily%20sort%20by%20last%20name%2C%20which%20is%20much%20more%20difficult%20if%20you%20stored%20the%20data%20as%20FULL%20NAME%20ONLY.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

HOLA TENGO PROBLEMA PARA  UTILIZAR  DOS COLUMNAS   Y  CREAR UNA SOLA  . EL PROBLEMA  ES  QUE  TENGO APELLIDO  EN UNA COLUMNA  Y NOMBRE EN  OTRA   NECESITO  TENERLOS EN UNA  SOLA  

MUCHAS  GRACIAS  

1 Reply

@PAULAPERALS 

 

You use the function CONCATENATE or CONCAT or the symbol & as follows, assuming last name is in column A, first name in Column B

 

=CONCATENATE(A2,", ",B2)   will give you Aperals, Paul

=A2&", "&B2      will give the same result

 

For what it's worth, you're better off with two columns as your basic data base, because it gives you a lot more flexibility in the long run. With two columns you can assemble the output as "Last Name, First Name" or "First Name Last Name";  you can also easily sort by last name, which is much more difficult if you stored the data as FULL NAME ONLY.