Hello,
I have a list of codes in column A of a worksheet. The codes in each cell are of varying length, containing spaces, numbers, and text.
I'm wondering if there's a way to create a macro (or even better, if there's an existing formula) to simply go down the list and remove the very first and very last character in each cell of column A.
For example, if cell A11 has "A56322 643 " (note the space at the end), B11 would read "56322 643" with the first character and the last space missing. Is this possible? I'm not very familiar with macros, especially those for editing text, so any help is greatly appreciated. Thank you all.
Bookmarks