Macro which delets in a cell all characters after comma
 

Hi guys !

I have a lot of cells with text , empty spaces etc . All cells contain
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 !


--
andrei
------------------------------------------------------------------------
andrei's Profile: 1056
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=193313

http://www.thecodecage.com/forumz

Macro which delets in a cell all characters after comma
 

Look in the vba help index for INSTRREV

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"andrei" wrote in message
...

Hi guys !

I have a lot of cells with text , empty spaces etc . All cells contain
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 !


--
andrei
------------------------------------------------------------------------
andrei's Profile: 1056
View this thread:
http://www.thecodecage.com/forumz/sh...d.php?t=193313

http://www.thecodecage.com/forumz

Macro which delets in a cell all characters after comma
 

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 befo
asdf,qwer,1234,erty
then you'll end up with:
asdf
when you're done.



andrei wrote:

Hi guys !

I have a lot of cells with text , empty spaces etc . All cells contain
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 !

--
andrei
------------------------------------------------------------------------
andrei's Profile: 1056
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=193313

http://www.thecodecage.com/forumz

--

Dave Peterson

Macro which delets in a cell all characters after comma
 

Yep , it works . Many thanks


--
andrei
------------------------------------------------------------------------
andrei's Profile: 1056
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=193313

http://www.thecodecage.com/forumz