Extract Numbers From A String

Joined
Apr 21, 2024
Messages
4
Reaction score
0
In column A of my worksheet I have a string of numbers e.g. 90351245 (in cell A1). I need to extract the last 3 digits in different columns. In cell B1 I need the 3rd digit from the right (2) displayed. In cell C1 (4) and in cell D1 (5). The function would be repeated for 20 lines. TIA.
 
Top