Find string and return both ends of either side

**ScabbyDog** · 03-28-2018, 05:13 AM

In column B I have words in every cell. What formula can search for ":" within the cell and return the first 2 characters to the left and to the right of ":".

So a cell might have "Data Job Word 09:15 Work Race" and I'd want to just return 09:15

**shukla.ankur281190** · 03-28-2018, 05:14 AM

Try

B1

Formula:

Please Login or Register  to view this content.

**ScabbyDog** · 03-28-2018, 05:24 AM

Works a charm.

Lastly, how would I alter it so that it searches for ":" and then returns me everything to the left of it except the first 3 characters. So from my example in the original post I'd like it to return "Data Job Word"

**shukla.ankur281190** · 03-28-2018, 05:31 AM

Then try

Formula:

Please Login or Register  to view this content.

Find string and return both ends of either side

LinkBack

Thread Tools

Rate This Thread

Display

Find string and return both ends of either side

Re: Find string and return both ends of either side

Re: Find string and return both ends of either side

Re: Find string and return both ends of either side

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] delete those parts of string which start with x and ends with y

[SOLVED] Return 2 digit numeral from either side of - in an alpha numeric string

Checking if the cell ends with a certain string of characters.

Find today's date in a text string in a column and return this string and....

[SOLVED] How Do I Find and Return a String When Only Part of that String is Known?

[SOLVED] Check if string ends with one of the strings from an array

[SOLVED] the ' symbol ends the SQL string, how do you replace it Excel

Bookmarks

Bookmarks

Posting Permissions