Find substring using vba

**doctorcpu** · 11-09-2018, 07:50 PM

I'm trying to find a string in a string and return everything after the colon as a string.

basestring: "my base string: this is a test"
string to find: "my base string:"

I've BEEN TRING INSTR but I only get a number that I thing is the starting position.

Any help will be appreciated.

**alansidman** · 11-09-2018, 08:05 PM

Here is a non-vba solution. Data is in A1

=RIGHT(A1,LEN(A1)-FIND(":",A1)-1)

**Richard Buttrey** · 11-09-2018, 08:19 PM

...if you really need VBA, and generally it's quicker to stick to Excl functions when they're available, then

Please Login or Register  to view this content.

Find substring using vba

LinkBack

Thread Tools

Rate This Thread

Display

Find substring using vba

Re: Find substring using vba

Re: Find substring using vba

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Find substring by mark

Help creating a formula to find a substring in a cell to a substring in another cell

how to find substring between first and third dashes?

Macro to search cells for substring and replace contents of cell if substring is found

Search substring within range, report the substring found

Find and Replace Substring

[SOLVED] Extract Substring, then Ignore that Substring, while collecting data from Other substrings

Bookmarks

Bookmarks

Posting Permissions