Converting Pipe Delimited Data String into Seperate columns using VBA Macro

**mikey42979** · 06-20-2014, 02:21 PM

Hi,

I have an excel workbook that gets data via web query usually looks like this for one of the columns MBRSHP_NEW/MBRSHP_BASIC/1/1, the web query updates on file open. I would like to take this part of the data that populates into column N and do a text to columns into a column i choose using the / as my delimiter. If it is possible to also have this run automatically on file open after the web query populates the data even better

.

Thanks,
Mike

Edit: I know / is not a pipe :p

**RudiS** · 06-20-2014, 03:15 PM

Would it be possible to upload a small sample of the data (desensitized), and also inform into which column you want to split the data. In other words, must the macro prompt you for a column to split it into? Please clarify.