I want the characters before the -

**Rockraizer** · 10-18-2021, 07:09 AM

Hello guyz!

I have a problem agin. I need to get the characters before the - symbol.

There's an example: smg153-grt-167445.23

Before the first - symbol the length of the characters not fix.

How can I get only before the first symbol the characters?

**Sam Capricci** · 10-18-2021, 07:12 AM

see if this works for you... =LEFT(A1,FIND("-",A1)-1)

**Rockraizer** · 10-18-2021, 07:17 AM

Originally Posted by Sam Capricci

see if this works for you... =LEFT(A1,FIND("-",A1)-1)

Sadly I'm already tried that and I've got a #N/A error.

**Sam Capricci** · 10-18-2021, 07:21 AM

you want smg153, correct?
Do you need to replace the commas with semicolons for your region? like =LEFT(A3655;FIND("-";A3655)-1)
it worked for me with that example, perhaps post a short sample workbook and if it is any question about what you want as an output then type in a few examples of what you want.

**bsalv** · 10-18-2021, 07:23 AM

Budapest ! regional settings !!!
Replace "," with ";" ???

Please Login or Register  to view this content.

**JohnTopley** · 10-18-2021, 07:34 AM

Try

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

**Rockraizer** · 10-22-2021, 08:23 AM

Thanks all of you guyz! That was my mistake because of the the regional setting as your wrote!

I want the characters before the -

LinkBack

Thread Tools

Rate This Thread

Display

I want the characters before the -

Re: I want the characters before the -

Re: I want the characters before the -

Re: I want the characters before the -

Re: I want the characters before the -

Re: I want the characters before the -

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Search string for specific characters, then output characters that reflect range

[SOLVED] Remove characters from cells if the have non data and characters as per attached sheet

[SOLVED] Replace accented characters in worksheet name to regular characters

VBA Characters() Function Fails when the Cell Content Exceeds 261 Characters

Formula to Limit the number of Characters and restrict selected characters

[SOLVED] VBA, remove all characters within a string, except numerical characters and full stops

Multiplying cells with leading characters, and retaining those characters in the result.

Bookmarks

Bookmarks

Posting Permissions