sakrams
Board Regular
- Joined
- Sep 28, 2009
- Messages
- 59
- Office Version
- 2016
- Platform
- Windows
Good Afternoon Excel Gurus,
Need help from the gurus with a quick formula to achieve the following result. I have a lot of sheets to fix and all sheets have 1000's of rows.
Column A has tags starting with numbers and some starting with characters. I am trying to write a formula that can convert the tags starting with characters to switch as shown in the table below. If the tag is starting with numbers remain with no change in a new column. Is there a quick way of achieving that?
<tbody>
</tbody>
https://i.postimg.cc/prD4w5dv/SS.jpg
Thanks a million in advance.
Need help from the gurus with a quick formula to achieve the following result. I have a lot of sheets to fix and all sheets have 1000's of rows.
Column A has tags starting with numbers and some starting with characters. I am trying to write a formula that can convert the tags starting with characters to switch as shown in the table below. If the tag is starting with numbers remain with no change in a new column. Is there a quick way of achieving that?
A | B | |
1 | 0002654-STL | 0002654-STL |
2 | 000322-ST | 000322-ST |
3 | 0005-STM | 0005-STM |
4 | 0012-STM | 0012-STM |
5 | 0016-STM | 0016-STM |
6 | 0019-STM | 0019-STM |
7 | 0020-STL | 0020-STL |
8 | 0020-STM | 0020-STM |
9 | 0021-STL | 0021-STL |
10 | 0021-STM | 0021-STM |
11 | 0050-STL | 0050-STL |
12 | 0075-STM | 0075-STM |
13 | 0076-STM | 0076-STM |
14 | 0078-STL | 0078-STL |
15 | STL-0001 | 0001-STL |
16 | STL-0005 | 0005-STL |
17 | STL-0010 | 0010-STL |
18 | STL-0011 | 0011-STL |
19 | STL-0013 | 0013-STL |
20 | STL-0014 | 0014-STL |
21 | STL-0016 | 0016-STL |
22 | STL-0017 | 0017-STL |
23 | SM-0004 | 0004-SM |
24 | S-0011 | 0011-S |
25 | STM-0013 | 0013-STM |
26 | STM-0015 | 0015-STM |
27 | STM-0054 | 0054-STM |
28 | STM-0055 | 0055-STM |
29 | STM-0057890 | 0057890-STM |
30 | STM-005877 | 005877-STM |
31 | SS-0001 | 0001-SS |
32 | STS-0004 | 0004-STS |
33 | STS-0006 | 0006-STS |
34 | STS-0007 | 0007-STS |
35 | STS-0008 | 0008-STS |
<tbody>
</tbody>
Thanks a million in advance.