VBA for TRIM

[topi1]

I have the following formula in the column B. It trims ":" and everything before that from A2 and places it in B2. Was hoping to get vba which will
a) do the same for all cells in the column B by looking at same row cell in the column A
b) Delimiter can be any cell from P1 to P10 and not necessarily ":".
c) Delimiter can be more than one word.
d) it is not case sensitive.

Thank you.

=TRIM(MID(A2,SEARCH(";",A2)+LEN(";"),255))

 

[Joe4]

I think you may have more luck if you post some sample data, covering different possibilities, along with your expected output (so much is dependent upon your data, so descriptions without seeing the data can often be unclear).

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.