Mrrrr's Forum (VIEW ONLY)
Un forum care ofera solutii pentru unele probleme legate in general de PC. Pe langa solutii, aici puteti gasi si alte lucruri interesante // A forum that offers solutions to some PC related issues. Besides these, here you can find more interesting stuff.
|
Nou pe simpatie:
Bianca777 din Brasov
 | Femeie
24 ani
Brasov
cauta Barbat
27 - 64 ani |
|
|
Mrrrr's Forum (VIEW ONLY)ReguliInregistrareLoginPozeNu sunteti logat. Lista Forumurilor Pe Tematici
|
| #1 |
|
|
I have a list of many rows of products that I previously converted to CSV 1-column style, separated by semicolons.
What I missed when I made the concatenation was that some products do not have the EAN code.
So now some of my lines have just 1 semicolon instead of 2 consecutive ones and if I want to use TEXTSPLIT to return to column-like data, it gets a bit messy.
So in the lines without EAN code, I would need the formula modified so it returns a blank cell.
The LET below does just that, by counting the number of semicolon separators:
=LET(
parts; TEXTSPLIT(A2; ";"; ; TRUE);
IF(COUNTA(parts)=3;
HSTACK(INDEX(parts;1;1); INDEX(parts;1;2); ""; INDEX(parts;1;3));
parts)
) |
_______________________________________
|
|
| |
|
