Hi everyone,
I have text data in the single cell in the following format.
<tbody>
</tbody>
I would like to extract the 3 data points in the [ ] brackets into adjacent cells if possible.
1. Quantity
2. Bps
3. Target Bps.
Any help would be greatly appreciated.
Kind regards,
Lewis.
I have text data in the single cell in the following format.
New Advice Requested 242.59 Target Bps, [ Quantity : 3,700, Bps : 0, Target Bps : 242.59 ] |
<tbody>
</tbody>
I would like to extract the 3 data points in the [ ] brackets into adjacent cells if possible.
1. Quantity
2. Bps
3. Target Bps.
Any help would be greatly appreciated.
Kind regards,
Lewis.