Hi all,
What is the formula to be used to extract number from a alphanumeric string located at different row?
example:
test123 test128 test131
test124 test129 test132
test125 test130 test133
test126 test131 test134
test127 test132 test135
test128 test133 test136
result:
123 128 131
124 129 132
125 130 133
126 131 134
127 132 135
128 133 136
Thanks & Best Regards,
Chiwai
Bookmarks