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.
|
Lista Forumurilor Pe Tematici
|
Mrrrr's Forum (VIEW ONLY) | Reguli | Inregistrare | Login
POZE MRRRR'S FORUM (VIEW ONLY)
Nu sunteti logat.
|
Nou pe simpatie:
morena28 Profile
 | Femeie
25 ani
Bistrita Nasaud
cauta Barbat
27 - 52 ani |
|
Mrrrr
AdMiN
 Inregistrat: acum 18 ani
Postari: 2314
|
|
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)
) |
_______________________________________
|
|
| pus acum 3 saptamani |
|