Split a cell into two cells
Solved
Pifoupif
Posted messages
26
Status
Member
-
Vaucluse Posted messages 27336 Registration date Status Contributor Last intervention -
Vaucluse Posted messages 27336 Registration date Status Contributor 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 answer
-
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
