find the position of an underline word in string.

**mouaffaq** · 11-22-2016, 06:10 PM

Hi guys;

Please help in this>

I have column A have data with 1 or more underlined word, i need to find the position of each underlined word in each string in cells;

i.e.

Hi How are you guys.

Result is 2,5. in cell B.

Could be one word or more.

Thanks A Lot.

**Subverter** · 11-23-2016, 05:35 AM

Assuming you have the data in Column "A" .. Try the following code:

Please Login or Register  to view this content.

**mouaffaq** · 11-23-2016, 05:52 AM

Thank you very much man
but i noticed that it only find the position of the first occurrence of the underline word
that means if a string have more than one underline word it should specify the position of all occurences positions separated by comma in B

**mouaffaq** · 11-23-2016, 05:57 AM

no its perfect
forget the last reply
there was some errors in my data
thanks man

**Subverter** · 11-23-2016, 06:14 AM

You welcome, ya m3allem 😁😁

**mouaffaq** · 11-25-2016, 10:05 AM

انته المعلم
ومنك نتعلم

**mouaffaq** · 11-27-2016, 05:59 AM

salam Bro
when applying the code to the whole data there were some cells without data in, and some with errors in calculating info for wordID,
you can find data in http://www.Almutadaber.com/excel.xlsx
there are 4 sheets.
kindly note that data to be calculated is in column B and your procedure should fill data in column D
also kindly note that this is a Quran project so data should be 100% accurate.
I appreciate if you can help me in this.

Thanks

find the position of an underline word in string.

LinkBack

Thread Tools

Rate This Thread

Display

find the position of an underline word in string.

Re: find the position of an underline word in string.

Re: find the position of an underline word in string.

Re: find the position of an underline word in string.

Re: find the position of an underline word in string.

Re: find the position of an underline word in string.

Re: find the position of an underline word in string.

Thread Information

Users Browsing this Thread

Similar Threads

Find the position of the first nr in a string

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

Add the word ERROR in the 133rd position after a string of characters in a cell

getting position of a word in a string

[SOLVED] find nth position of a string

find position of a number in a string

[SOLVED] find position of a number in a string

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions