Split String

**calvinle** · 10-31-2016, 05:05 PM

Hi,

Is there a way to split a string to remove the rest of the string once it has the symbol $ in it?

Example:
JOHN$$$$ = JOHN
STEVEN$HH = STEVEN
RICHARD$$$$H = RICHARD

Thanks

**zbor** · 10-31-2016, 05:08 PM

You don't need macro.

Here, try this:

Formula:

Please Login or Register  to view this content.

**zbor** · 10-31-2016, 05:08 PM

You don't need macro.

Here, try this:

Formula:

Please Login or Register  to view this content.

**shg** · 10-31-2016, 05:37 PM

Or ...

	A	B	C
1	JOHN$$$$	JOHN	B1: =LEFT(A1, FIND("$", A1) - 1)
2	STEVEN$HH	STEVEN
3	RICHARD$$$$H	RICHARD

**S O** · 10-31-2016, 05:38 PM

If you did want VBA though...

Please Login or Register  to view this content.

**calvinle** · 10-31-2016, 06:34 PM

Great!! Thanks guys.!!

Split String

LinkBack

Thread Tools

Rate This Thread

Display

Split String

Re: Split String

Re: Split String

Re: Split String

Re: Split String

Re: Split String

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Split string and apply function on string parts

[SOLVED] Split String at every "/" then put split string results into a multiline textbox.

How to split a string based on a sub string

Advanced Split Function: Need to pull text string in quotes, within a text string

need to split string(s)

Can excels Split() function split a string up at multiple spots?

Excel 2007 : split string

Bookmarks

Bookmarks

Posting Permissions