Output nth number from a single input?

[Svextra]

I have a single cell with a few numbers, along with other information, for example: [9273, 9274, 9329, 9342]

I want to output each number in an individual cell. How can I do this?

Here's an image for reference: https://i.imgur.com/bu1dzix.png

 

[VBA Geek]

Use TextToColumns https://support.office.com/en-us/article/split-text-into-different-columns-with-the-convert-text-to-columns-wizard-30b14928-5550-41f5-97ca-7a3e9c363ed7

 

[Svextra]

Use TextToColumns https://support.office.com/en-us/article/split-text-into-different-columns-with-the-convert-text-to-columns-wizard-30b14928-5550-41f5-97ca-7a3e9c363ed7

Thank you for your response, but this needs to be done with functions. My apologies for not specifying.

 

[VBA Geek]

Excel 2010
	A	B	C	D	E	F
1	[9273, 9274, 9329, 9342]		9273	9274	9329	9342
Sheet12

Cell Formulas
Range	Formula
C1	=TRIM(MID(SUBSTITUTE(MID(LEFT($A1,LEN($A1)-1),2,LEN($A1)-2),",",REPT(" ",100)),COLUMNS($C1:C1)*99-98,99))
D1	=TRIM(MID(SUBSTITUTE(MID(LEFT($A1,LEN($A1)-1),2,LEN($A1)-2),",",REPT(" ",100)),COLUMNS($C1:D1)*99-98,99))
E1	=TRIM(MID(SUBSTITUTE(MID(LEFT($A1,LEN($A1)-1),2,LEN($A1)-2),",",REPT(" ",100)),COLUMNS($C1:E1)*99-98,99))
F1	=TRIM(MID(SUBSTITUTE(MID(LEFT($A1,LEN($A1)-1),2,LEN($A1)-2),",",REPT(" ",100)),COLUMNS($C1:F1)*99-98,99))