Extract data from a string

[ed.ayers315]

Hello forum goers,

Need to extract only the numbers from the below string in A88.

I need these numbers in individual cells in Row 88 from column K:FW

<TABLE style="WIDTH: 439pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=585><COLGROUP><COL style="WIDTH: 439pt; mso-width-source: userset; mso-width-alt: 21394" width=585><TBODY><TR style="HEIGHT: 30pt" height=40><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #92d050; WIDTH: 439pt; HEIGHT: 30pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl64 height=40 width=585>4, 43, 43, 53, 57, 57, 58, 58, 58, 58, 58, 58, 59, 59, 57, 58, 58, 57, 57, 58, 58, 58, 58, 58, 58, 58, 58, 59, 59, 58,</TD></TR></TBODY></TABLE>

The problem I have had trying to do this is it is varible: sometimes 1, 2, 3 digits between the commas. Length is also varible.

 

[VoG]

Have you tried Data > Text to Columns, Delimited with comma as the delimiter.

 

[ed.ayers315]

No, how do you do that, sounds promising.

Thanks

 

[VoG]

Best to try this with a copy of your sheet.

Click in A88, Data > Text to Columns, tick Delimited, click Next, tick Comma then click Finish.

 

[ed.ayers315]

That works, is there a formula solution as well?

Thank you

 

[VoG]

I can't think of any formula that wouldn't be hugely complicated.

VBA code would be relatively straightforward.

 

[ed.ayers315]

I am glad to hear it would be complicated being I spent so much time trying to figure it out.

Thanks for your help, I will go with the Text to Columns.