Find indexnumber of substring in string

**MaartenRo** · 03-19-2021, 02:40 AM

Hi,

I would like to have a macro that searches the index number of "test" in a cell A2. For example if the string in cell A2 is 111test11 than B2 should display 4. How can i do this?

I made this function but it doesn't work:

Please Login or Register  to view this content.

Any input is much appreciated!

**nankw83** · 03-19-2021, 02:46 AM

What's happening ? Are you getting any error ? I tried your code & it's working fine

Edit : If you're using a loop "For each c in range" then you're referencing cell A2 always ...

**MaartenRo** · 03-19-2021, 06:11 AM

Thanks it works

Find indexnumber of substring in string

LinkBack

Thread Tools

Rate This Thread

Display

Find indexnumber of substring in string

Re: Find indexnumber of substring in string

Re: Find indexnumber of substring in string

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] ForLoop to Find string value as part of substring in another cell

[SOLVED] Find substring in range and categorise cells in range based on substring found

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

VLOOKUP to find a substring exist in another column of list string

[SOLVED] Find substring within a string, from a list

[SOLVED] Find the position of a substring in a string

Find the sub string in column and copy the cell next to the substring

Bookmarks

Bookmarks

Posting Permissions