Forum Discussion
Change letter and numbers
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
I don't think Libre has TEXTJOIN() and SEQUENCE(). It's better to ask Libre community how to solve the task.