I noticed you were looking for a function rather than a subroutine. The attached file contains a function (BoldParse) that parses your strings. Use whichever meets your needs. Tom
On Wed, Nov 12, 2008 at 2:27 AM, atta khan <[EMAIL PROTECTED]> wrote: > Hello All, > > What i want to do is to separate BOLD text from a string by a formula or VB > function. As I have a lot of data I can't do it manually. > > For example > > *East Doncaster* Victoria, Australia. > > I want "East Doncaster" in one column and "Victoria, Australia" in other. > > Please provide help > > thanx > > [EMAIL PROTECTED] > +923005146707 > > > > --~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~----------~----~----~----~------~----~------~--~---
ParseBold.xls
Description: MS-Excel spreadsheet
