How do i add parts of strings if the rest of the sting matches a certain given string?

**Terminator555** · 08-31-2023, 04:25 AM

Example:

A	B	C	D	Result if only numbers between "Hello" and "GoodMorning" are added:
Hello54GoodMorning	Hello7GoodMorning	GoodMorning9GoodMorning	Hello8Hello	61 (How do i get this automated?)

**JohnTopley** · 08-31-2023, 04:33 AM

Please post a workbook with a more realistic sample of your data WITH expected results.

See yellow banner at top of page on how to attach a workbook,

**Jacc** · 08-31-2023, 04:34 AM

Post a sample workbook

**Terminator555** · 08-31-2023, 04:38 AM

After minutes of trying i wasnt able to attach a workbook. However I think the given example is understandable. It does not matter if my example is realistic since i just want to know how i solve such a problem.

**Jacc** · 08-31-2023, 04:51 AM

Like this?

Formula:

Please Login or Register  to view this content.

Replace text with cellreferences as needed.

**Terminator555** · 08-31-2023, 04:53 AM

Well i want to add all the numbers between hello and good morning

**JohnTopley** · 08-31-2023, 05:53 AM

Try

Formula:

Please Login or Register  to view this content.

**popipipo** · 08-31-2023, 06:37 AM

Please Login or Register  to view this content.

A1= Hello Goodmorning
B1=61
Result= Hello 61 Goodmorning
Try this

**Jacc** · 08-31-2023, 08:25 AM

Here is some instructions of how to upload a workbook.

How do i add parts of strings if the rest of the sting matches a certain given string?

LinkBack

Thread Tools

Rate This Thread

Display

How do i add parts of strings if the rest of the sting matches a certain given string?

Re: How do i add parts of strings if the rest of the sting matches a certain given string?

Re: How do i add parts of strings if the rest of the sting matches a certain given string?

Re: How do i add parts of strings if the rest of the sting matches a certain given string?

Re: How do i add parts of strings if the rest of the sting matches a certain given string?

Re: How do i add parts of strings if the rest of the sting matches a certain given string?

Re: How do i add parts of strings if the rest of the sting matches a certain given string?

Re: How do i add parts of strings if the rest of the sting matches a certain given string?

Re: How do i add parts of strings if the rest of the sting matches a certain given string?

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Get strings between two strings in text file and remove the rest

[SOLVED] Locking specific parts of a worksheet while the rest remains unprotected

[SOLVED] Locking specific parts of a worksheet while the rest remains unprotected

Display a sting of consecutive numers, then the rest

[SOLVED] search for parts of strings in another list of strings

Value manipulation, String to Int, Int to Sting

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions