My data in col A is as follows:
- 1*15
- 101268*6
- 101352*16
- 101513*11
- 10406*2
- 10406*37
- 10411*13
- 10411*7
I want to add two columns with the data preceding the * going into Col B and the data following the * going into Col C. I can't use RIGHT or LEFT because the data is not the same length. If someone knows a way to do this, I'd certainly appreciate knowing how. Thanks in advance.
Bookmarks