need to seperate one cell's formula by delimiters

[fynn]

Hey all,

My first post here and after alot of Excel work I finally have a VB
problem thats got me stumped!

So, I have a Listbox that when a save button is pressed, dumps th
values it holds into a cell, with each value separated by "," as
delimiter. The output looks something like this:

,itemA,itemB,itemC, and so on. Each entry is a set phrase so the lengt
or content doesnt change, just the contents of the cell (according t
which entries the user has put into the listbox)

What I need is a routine that will take that output into a string, the
put the words that are between the "," into their own strings or cell
like a delimiter or separator. Is this possible? My programming so fa
isnt set in stone so some changes are possible, if anyone can sugges
anything!!

Thanks in advance,
Fyn

 

[Ron de Bruin]

Hi fynn

Try Data>Text to columns in the menubar