<div>
could you copy all of the data to a text file, then reimport the data back into excel from the text file with the delimiter as a :?
</div>


<div>
Thats certainly easier than my suggestion Barry. didnt know they added that functionality :)
</div>


<div>
Getsum_Bloo... This has been around since, uhm, Excel 2000 at least, if not earlier
</div>


<div>
dang... thanks... learned something new today. :)
</div>


<div>
<div class="content wysiwyg-content">
in a field i have a data like this APPLE:PHONES:NEW:iPad 16GB 3G White<br />
<br />
i need seperate them like APPLE in next cell PHONES NEW next cell ipad 16gb 3g white. basically i need to seperate all before or after :<br />
for first one i made like left(cell,find(&quot;:&quot;,cell)-1<wbr />)<br />
<br />
how can i do for all those like that.
</div>
</div>


in a field i have a data like this APPLE:PHONES:NEW:iPad 16GB 3G White

i need seperate them like APPLE in next cell PHONES NEW next cell ipad 16gb 3g white. basically i need to seperate all before or after :
for first one i made like left(cell,find(":",cell)-1)

how can i do for all those like that.

could you copy all of the data to a text file, then reimport the data back into excel from the text file with the delimiter as a :?

Thats certainly easier than my suggestion Barry. didnt know they added that functionality :)

Getsum_Bloo... This has been around since, uhm, Excel 2000 at least, if not earlier

dang... thanks... learned something new today. :)

excel 2010 help

in a field i have a data like this APPLE:PHONES:NEW:iPad 16GB 3G White

i need seperate them like APPLE in next cell PHONES NEW next cell ipad 16gb 3g white. basically i need to seperate all before or after :
for first one i made like left(cell,find(&quot;:&quot;,cell)-1)

how can i do for all those like that.

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.