Macro which delets in a cell all characters after comma

A

andrei

Hi guys !

I have a lot of cells with text , empty spaces etc . All cells contai
a "," (comma) . I need a macro that delets all after that comma
including comma . I give in example :

A1 : mother, father

The result should be :

A1 : mother

Many thanks !
 
D

Dave Peterson

If you want to get rid of everything after the first (or only) comma, you could
record a macro when:

You select the range to fix
edit|replace
what: ,* (comma followed by an asterisk)
with: (leave blank)
replace all

Be aware that if your data looks like this before:
asdf,qwer,1234,erty
then you'll end up with:
asdf
when you're done.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

macro which delets cell if the cell above has the same keyword 2
Need macro that analyses 2 columns . Delets row if same text is fo 3
Macro that splits content from cell if given character is found 4
Macro which searches for a character . When found delets what's be 4
Macro that delets rows if keyword is found 2
Macro/function that keeps in a cell a given number of characters 1
Function/Macro that keeps first X characters in a cell and delets rest 3
Macro - reads cells in a column .If keyword found moves cell conte 5

Top