Is it possible to split a cell in to multiple cells based on the condition?
If a cell contains a value like (A01626*A01666*6*A01656*A01696)/(A01646*100*A01676*6*1.1) in Cell A1, then is it possible to split to multiple cells only the value starts with A0? Like shown in below picture?
Are the strings you want to pull out always going to be 6 characters? If not what the characters do we want to exclude? Just "(" , ")" , "/" and "*" ?
If it is always 6 characters then here is VBA solution based on selecting the range containing the cells to be split if that works for you. If it is not always 6 characters let me know what the seperator characters need to be and I will rejig this.
Dim Cell As Range Dim i As Integer Dim Position As Integer Dim Search As String Dim Start As Integer
Search = "A0"
For Each Cell In Selection
i = Cell.Column + 1
Start = 1
Position = InStr(Start, Cell.Text, Search, vbTextCompare)
If Position > 0 Then Start = Position + 1 Cells((Cell.Row), i).Value = Mid(Cell.Text, Position, 6) i = i + 1 End If