Extract all values surrounding a special character

[mvpromo]

Hi Folks, -- I am pulling my hair out. I have an excel file that has the following in a cell:

[TABLE="width: 232"]
<tbody>[TR]
[TD="class: xl63, width: 232"]15005~40450~STDREG07~40452~STDREG81~05989001~12102003~33083002~11939004

I need to extract these values surrounding the tilde (~). Does anybody have any bright ideas? I really don't want to go through 8000 lines of spreadsheet.

I am using Excel 2010

thanks!

Steve Jackson [/TD]
[/TR]
</tbody>[/TABLE]

 

[Jonmo1]

Try Data - Text To Columns - Deliminated - Other ~ - Finish

 

[mvpromo]

That worked perfectly! Thanks. For those of you reading this post -- I put my columns on the end of my spreadsheet -- sine text to columns seemed to overwrite any adjacent columns. Other than that, It worked like a charm, and I had forgotten about how powerful text-to-columns really was.

 

[Jonmo1]

Glad to help.


Note, surely it gave you a popup warning before it actually overwrote adjescent columns.
Something like
"Do you want to replace the contents of the destination cells?"
With an option to choose OK or Cancel.