Extract the first characters inside a cell up to a delimiter

**pickslides** · 02-23-2014, 06:56 PM

Hi

I have a list of names in the following format but only want to extract the first part of the string until the comma

List

Smith, John
Mc Donald, Jesse
Jones, Bob
Dexter, Ian

Desired Output

Smith
Mc Donald
Jones
Dexter

Thanks, MQ

**pickslides** · 02-23-2014, 07:19 PM

Got it!

=LEFT(A2,FIND(",",A2)-1)

**pickslides** · 02-24-2014, 08:50 PM

And the reverse would be RIGHT(F28,LEN(F28)-(FIND(",",F28))

Extract the first characters inside a cell up to a delimiter

LinkBack

Thread Tools

Rate This Thread

Display

Extract the first characters inside a cell up to a delimiter

Re: Extract the first characters inside a cell up to a delimiter

Re: Extract the first characters inside a cell up to a delimiter

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] How to extract 3 last words from an excel cell using a predefined delimiter?

Can I extract certain words from inside a cell?

Show Characters Left of Delimiter (,)

Counting special characters inside a cell.

counting characters inside a cell

Bookmarks

Bookmarks

Posting Permissions