need to seperate one cell's formula by delimiters
 

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

--
fyn
-----------------------------------------------------------------------
fynn's Profile: http://www.excelforum.com/member.php...fo&userid=3542
View this thread: http://www.excelforum.com/showthread.php?threadid=55193

need to seperate one cell's formula by delimiters
 

Hi fynn

Try DataText to columns in the menubar

--
Regards Ron De Bruin
http://www.rondebruin.nl



"fynn" wrote in message
...

Hey all,

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

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

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

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

Thanks in advance,
Fynn


--
fynn
------------------------------------------------------------------------
fynn's Profile: http://www.excelforum.com/member.php...o&userid=35424
View this thread: http://www.excelforum.com/showthread...hreadid=551931