I started a simple excel list. At this point, I have over 20000+ entries, and
I just realized that text in column A should actually be placed in another
column. For example, If column A has the following values:
T16256
F56236
G89562
I would want to see text such as
Tooling
Fixture
Gauge
in column F and have that letter in Column A taken out. The other problem
is, not all of the cells in column A start with the alpha character, some
are numeric only, and others have alpha characters after position 1 that I
would not want to include.
I'm not exactly profecient in Excel, I think I can somehow do this with a
multi-step conditional format or validation of the columns, but I'm just not
sure where to start. I'm hoping this doesn't require the writing of a macro,
I'm a little lost here.
Can anyone help point me in the right direction, I would be very grateful.
Thanks,
Jacky D.