View original (French)

Inverse of the concatenate function

Solved
ali -  
 Jiji -
Hello,
to assemble several strings into one, we use the concatenate function.
And if now we want to do the opposite, is there an Excel function that addresses that? Thank you. 
Configuration: Windows XP Internet Explorer 6.0

1 réponse

Réponse 1 / 1
m@rina Posted messages 27165 Registration date   Status Modérateur Last intervention   11 541
 
Good evening,

If the words are separated by a particular character such as a space, comma, etc., you can use the conversion function:

Select the column, Data => Convert => Delimited

m@rina
--
- "On the office forum, questions regarding office automation are asked..."
- "Oh really ???"
18
ali
 
Thank you very much.
0
said
 
thank you very much, that's handy
0
Oni
 
Hello
You can also use the FIND, LEFT, and RIGHT functions

if text is in A1

in B1 =LEFT(A1;FIND(" ";A1;1))
in C1 =RIGHT(A1;LEN(A1)-FIND(" ";A1;1))

A1 : Last name first name
B1 : Last name
C1 : First name
0
flavien
 
thank you
0
Jiji
 
Thank you!
0