Thanks for taking the time to respond to this post. I appreciate your help.
The Problem: See attached file. I have data of variable row length presented in two columns. The data (in column b) appears as "4, Database 3, Database 4, Database 9, Database 10". I need to extract the first numeric text phrase (numbers from 1-10) into a separate column (column c) and extract the remaining text into another column (column d). The remaining text can be of variable length, but is always presented as alphanumeric text with commas if there is more than one.
Thank you!
Bookmarks