How to extract the 4 digits from a string after # for e.g
G451Z274#H229#S145T291#R129 I want the outcome to be
<code>G451 into column T1
H229 into column S1
S145 into column P1
R129 into column F1
</code>
<code>G451 into column T1
H229 into column S1
S145 into column P1
R129 into column F1
</code>
G451 into column T1
H229 into column S1
S145 into column P1
R129 into column F1
I tried (left, 4) and (right, 4) but its not working.
New contributor
Maga Maga is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
3