Deleting all characters Right of a comma

[Zan03]

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]

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

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

[mdbct]

I got an error due to the curly quotes.

“ vs "

try this one:

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

[Zan03]

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

I got an error due to the curly quotes.

“ vs "

try this one:

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

[martindwilson]

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

[Zan03]

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