I would like to request your help in writing a vba code that will split all cells in a selected range, based on the following criteria (Please refer to Excel attachment for all column references):
Find the last instance of the character ":" (colon) for each cell in column B and split into two columns. (If no colon found, copy and paste full cell string into column C
Split Column D (text to column) by using the character "-" (hyphen) as the delimiter
Ultimately the columns that will be useful for my purposes will be D, and F, which are the account number and account description. Down the road I will need to figure out how to delete column E, since I won't need, but I can try to figure that part out later on.
Thank you very much for any help you can provide.