about excel

By AyukNotna ·
Using VBA, I need help guys on how to write a VB code that will read the contents of a cell and identify delimeters or special characters, for example:

say this line is in A1: "Ben (NJ), Anton(FL)"

I want to put Ben and Anton in one column under name and NJ and FL into another column under state and omit the ( and ). I'm planning to store the result in a different worksheet.

I appreciate it guys.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Share your knowledge

Related Discussions

Related Forums