Trying to modify this 'text to rows' code to only use semicolons as delimiters

**MKBR** · 01-23-2014, 12:24 PM

Hello All,

I've been trying to modify the below code to only require one semicolon as a delimiter between the data I need separated.

I currently have data like this 'John Smith;Ed Jones;Bob Thomas' which is all in a single cell, but I want to separate the names into individual rows, copying and inserting the data from all of the rows like this current code does.

I believe I can omit most of the bottom half since I'm only dealing with one delimiter, not parenthesis and brackets like this macro does.

Please let me know if you need any other information.

Please Login or Register  to view this content.

Thanks!
Mike

**protonLeah** · 01-23-2014, 05:10 PM

To attach a Workbook
(please do not post pictures of worksheets)

Click Advanced (next to quick post),
Scroll down until you see "Manage Attachments",
Click that then select "add files" (top right corner).
Click "Select Files" find your file, click "open" click "upload"
Once the upload is completed the file name will appear below the input boxes in this window.
Click "Done" at bottom right to close the Attachment Manager.
Click "Submit Reply"

**MKBR** · 01-24-2014, 09:56 AM

Thank you for the information protonLeah, please see the attachment below. In the current worksheet I'm only concerned with users in the 6th column (F). Also, I'm getting closer to what I'm looking for with the below code, but now it's separating the names and then leaving the original names in the original field, if that makes any sense.

Please Login or Register  to view this content.

-Mike

**MKBR** · 01-24-2014, 01:17 PM

I kept plugging away at this and was able to accomplish what I needed with the following. The find and replace below the variables removes the OU information from the users.

Please Login or Register  to view this content.

Trying to modify this 'text to rows' code to only use semicolons as delimiters

LinkBack

Thread Tools

Rate This Thread

Display

Trying to modify this 'text to rows' code to only use semicolons as delimiters

Re: Trying to modify this 'text to rows' code to only use semicolons as delimiters

Re: Trying to modify this 'text to rows' code to only use semicolons as delimiters

Re: Trying to modify this 'text to rows' code to only use semicolons as delimiters

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Sort Text into Rows by Multiple Delimiters/Values

[SOLVED] Modify code to transpose a stack of data to rows on to delimit on text hone number field

Modify VBA code to hide blanks rows

Question on Delimiting Text in Cell for phrases before and after semicolons

[SOLVED] How Do I Modify Pearson's Code to Add "Treat Consecutive Delimiters As One"?

Bookmarks

Bookmarks

Posting Permissions