Deleting all characters Right of a comma

**Zan03** · 04-16-2010, 09:17 AM

Hi All,

I'm using the following comma to delete all characters right of a comma... any ideas why it's not working?

=LEFT(a1,FIND(“,”,A1)-1)

**martindwilson** · 04-16-2010, 09:25 AM

those are the wrong "" you are using char148 " is char 34

try
=LEFT(A1,FIND(",",A1)-1)

**mdbct** · 04-16-2010, 09:26 AM

I got an error due to the curly quotes.

“ vs "

try this one:

Please Login or Register  to view this content.

**Zan03** · 04-16-2010, 09:28 AM

yeah, you're right... your code works perfectly... Thanks for the help!

Originally Posted by mdbct

I got an error due to the curly quotes.

“ vs "

try this one:

Please Login or Register  to view this content.

**martindwilson** · 04-16-2010, 09:28 AM

mind you if you just want to delete everything to right of comma including the comma use find /replace
find ,* replace with nothing

**Zan03** · 04-17-2010, 09:20 AM

Thanks Martin.. i've made a mental note.. hopefully it sticks around for next time i need it!

Re: Deleting all characters Right of a comma