Forum Discussion
Change letter and numbers
nekbv If you are on a recent version of Excel that supports both TEXTJOIN and SEQUENCE, the attached workbook contains a working example.
- nekbvOct 21, 2020Copper Contributor
Riny_van_Eekelen At home I use Microsoft Office 2010, but at work (where I need this xls) we use Libre last version. This is what I see when I use Libre.
My SKU Manufacturer SKU mfgcode mycode
EV1A05 #NAME? A Z
EV1A01 #NAME? B Y
EG1A03 #NAME? C X
WL1A02 #NAME? D W
DL307 #NAME? E V
SH1A04 #NAME? F U
G T
H D
I R
J Q
K P
L O
M N
N M
O L
P K
Q J
R I
S H
T G
U F
V E
W D
X C
Y B
Z A
0 9
1 8
2 7
3 6
4 5
5 4
6 3
7 2
8 1
9 0- SergeiBaklanOct 21, 2020Diamond Contributor
I don't think Libre has TEXTJOIN() and SEQUENCE(). It's better to ask Libre community how to solve the task.