break a text string and export to cell range

[beachie2037]

Hi All,

I am creating a pricing list and from a few hundred possible optio
select only a small percentage. Those options are CONCATENATED into
cell and seperated by a delimiter (#).

Simply cell A1= option a#option c#option q#option r#

I need to break this list up so I can see clearly the selecte
options.

How can I break this apart at the delimiter and place output in cells
Something like:

c1= option a
c2= option c
c3= option q
c4= option r

If there is a better way to go about this Im open to suggestions.

Thank

 

[dave]

I'd use the text to columns feature as follows...
Data menu, text to columns, select delimited, uncheck
everything except "other:" and type "#" in its space.
this will put it into a1 b1 c1 and d1. If you need them
in c1-c4, you can either link them directly or use the
transpose function(depending on how many cells you need
converted, there are different methods for additional
automation) Let me know how many cells you need to
convert and I'll let you know whether its worth
additional fanciness..
hth,
Dave