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:

=TRIM(LEFT(SUBSTITUTE(A1,"$",REPT(" ",255)),255))

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

You don't need macro.

Here, try this:

Formula:

=TRIM(LEFT(SUBSTITUTE(A1,"$",REPT(" ",255)),255))

**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...

Dim originalString As String, delim As String, result As String

originalString = "John$$Example"
delim = "$"

result = Left$(originalString, InStr(originalString, delim) - 1)

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

Great!! Thanks guys.!!

Split String

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

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