Split a cell into two cells
Solved
Pifoupif
Posted messages
26
Status
Membre
-
Vaucluse Posted messages 27336 Registration date Status Contributeur Last intervention -
Vaucluse Posted messages 27336 Registration date Status Contributeur Last intervention -
Hello everyone,
I have cells (in a column) with text (in this case, football matches of the type
A1: "psg v marseille").
I want to separate these cells into two distinct columns (A1: "psg" B1: "marseille") while removing the "v" if possible.
Thank you for your help.
I have cells (in a column) with text (in this case, football matches of the type
A1: "psg v marseille").
I want to separate these cells into two distinct columns (A1: "psg" B1: "marseille") while removing the "v" if possible.
Thank you for your help.
1 réponse
Hello
two options:
1°) select the column
Ribbon / Data / convert
in the window check: "delimited"
next window: "other" and enter "v" in the box
"finish"
2° by formula:
if starting in A1
=LEFT(A1,FIND(" v ",A1))
and in B1:
=RIGHT(A1,LEN(A1)-FIND(" v",A1)-2)
make sure to properly surround the v with a space on each side to avoid confusion with v in the text.
This option assumes that the v is properly surrounded by two spaces
best regards
--
To err is human, to persist is diabolical
two options:
1°) select the column
Ribbon / Data / convert
in the window check: "delimited"
next window: "other" and enter "v" in the box
"finish"
2° by formula:
if starting in A1
=LEFT(A1,FIND(" v ",A1))
and in B1:
=RIGHT(A1,LEN(A1)-FIND(" v",A1)-2)
make sure to properly surround the v with a space on each side to avoid confusion with v in the text.
This option assumes that the v is properly surrounded by two spaces
best regards
--
To err is human, to persist is diabolical
solution 1: the problem is that Excel takes all the v's from the text (I end up with several columns knowing that there are several v's.
solution 2 more suitable in this specific case.
thanks!
Safe travels
best regards