intPos = InStr(1, str, "|") strText = Right(str, Len(str) - intPos)'get abcd then repeat
--- verly yuli <[EMAIL PROTECTED]> wrote: > hello all > > i have a example text > abcde|ajhiu|reiek > how to split this text to row? > > thank you for all support > > regards warmest > > > verly yuli > > > > ____________________________________________________ > Sell on Yahoo! Auctions no fees. Bid on great > items. > http://auctions.yahoo.com/ > ____________________________________________________ Sell on Yahoo! Auctions no fees. Bid on great items. http://auctions.yahoo.com/ Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
