NorthbyNorthwest
Board Regular
- Joined
- Oct 27, 2013
- Messages
- 154
- Office Version
- 365
Hi, everyone. Hope someone can help. I have a column in which each cell contains one, two, three or more bracketed sets of numbers. Example: [2784][7115][3412]. No spaces between the brackets. I need to break these bracketed numbers out into individual column cells, preferably with brackets removed. But brackets remaining is OK too. I have been working with new TEXTSPLIT" function without success. Does anyone know of a formula which would accomplish this?