Macro to delete set columns and rows

You don't have to use variables like I have, but this will let you adjust this idea more easily. You can see where you enter the ranges, and the worksheet name. It would need to be run from the workbook with the worksheet (that's what "thisWorkbook" means).

So, put this in a code module in that workbook and it should be fine.

Please Login or Register  to view this content.

No problem. If this answers your question, please mark your thread [Solved].

To do that, edit your first comment. Press "Go Advanced" and add the [Solved] prefix.

"Text to Columns" is a built in feature of Excel. You can try that, it's found under the Data tab on the excel ribbon. You would tell excel that the text is "delimited" by / and by space.

A delimiter is a character that tells excel where to break apart the text.


OR - you could use string functions to handle the values for first, last, middle initial and title.

If the value "Chiang/Kevin C MR" is sitting in A2:

First name is given by: =MID(A2,FIND("/",A2)+1,FIND(" ",A2)-FIND("/",A2)-1)

Last names is given by: =LEFT(A2,FIND("/",A2)-1)

Middle Initial is given by: =MID(A2,FIND(" ",A2)+1,1)

Title is given by: =RIGHT(A2,LEN(A2)-FIND(" ",A2,FIND(" ",A2)+1))