Breaking up Array Cell Value

[GoDawgs]

I get a daily file with hundreds of records from an outside vendor...and one of the columns in the file has arrays in each cell. Is there an easy way to break these apart? My final goal is to get them somewhat normalized (meaning a record for each of the values in the array), but I'd settle for columns for each piece at the moment.

The Text-To-Columns function basically does this, but I was hoping there was another way I'm missing since each record could have a different number of fields in the array, which makes for a messy next few steps.

At worst I'm probably stuck doing this in VBA...but people on this site always come up with things I'd never even thought of...so I'm crossing my fingers.

Here's what one cell looks like:

{Digital Phone (New) Elk Grove| CA|HSI 1MB and up (New) Elk Grove| CA|DISH Network by Frontier (New) Elk Grove| CA}


Thanks for any help.

Kevin

 

[SkipVought]

Hi,

Check out Data/Text to columns... - Delimited

Skip,

_[red][/red]

 

[GoDawgs]

Thanks Skip...that's what I had set up but was hoping to find something else...although I don't really know what that something else might've been. I'll work with it...thanks for the help.

 

[SkipVought]

If you were using VBA code, there would be.

Skip,

_[red][/red]