I need to create a new column based on an existing column of data. For example:
Existing column contains the format ABC123DEF, what is the best way to create a new column to pull BC1, or ABC from the existing column?
Thanks in advance to all suggestions!!
Bookmarks