delete text after comma

[Vanda_a]

hello all.
please help me solve this thing.

how can I delete text after a comma.

from this 638264,1 to 638264

another question. this "&" is to join two or more cells. what is the opposite of that function?

	A	B	C
1	8768,1	,1	8768
2	1683,34	,34	1683

<tbody>
</tbody>

A-B=C

Thank you in advance.

 

[Andrew Poulsom]

Try:

=RIGHT(A1,LEN(A1)-FIND(",",A1)+1)
=LEFT(A1,FIND(",",A1)-1)

Excel doesn't have the equivalent of VBA's Split function (unfortunately).

 

[Matt Rogers]

Hi.

how can I delete text after a comma.

<table border='1' cellspacing='0' cellpadding='2' valign='middle' colspan='3' style='font-family:Calibri; color:#000000; background-color:#FFFFFF; font-size:11px; font-weight:normal; font-style:normal; '><colgroup><col width='28pt'><col width='60pt'><col width='60pt'></colgroup><tr style='background-color:#cacaca'><td> </td><td align='middle'>A</td><td align='middle'>B</td></tr><tr><td style='background-color:#cacaca' align='middle'>1</td><td align='right' >8768,1</td><td align='right' >8768</td></tr><tr><td style='background-color:#cacaca' align='middle'>2</td><td align='right' >1683,5</td><td align='right' >1683</td></tr><tr><td style='background-color:#cacaca' align='middle'>3</td><td align='right' >12345,999</td><td align='right' >12345</td></tr></table><br><table border='3' cellspacing='0' cellpadding='2' valign='middle' colspan='2' style='table-layout:auto; color:#000000; background-color:#FFFFFF; font-family:Calibri; font-size:10px;'><colgroup><col width='40pt'><col></colgroup><tr style='background-color:#eeaaaa'><td>Cell</td><td>Formula</td></tr><tr><td>B1</td><td><Span style='color:#222222'>=INT</Span><Span style='color:#0000DD'>(A1)</Span><Span style='color:#222222'></Span></td></tr></table>

 

[Peter_SSs]

Other options

how can I delete text after a comma.

from this 638264,1 to 638264

1. Select the column.
2. Use Find/Replace with Find what: ,* Replace with: leave blank, In Options>> ensure 'Match entire cell contents' is not checked, Replace All

another question. this "&" is to join two or more cells. what is the opposite of that function?

Have a look in Excel's built-in Help for "Text to Columns" (with delimiter)

 

[Vanda_a]

Other options
1. Select the column.
2. Use Find/Replace with Find what: ,* Replace with: leave blank, In Options>> ensure 'Match entire cell contents' is not checked, Replace All


Have a look in Excel's built-in Help for "Text to Columns" (with delimiter)

Many thanks. I have tried it but the problem is after replace, all the numbers go 3.35E+12. It leaded me to come here....

 

[Vanda_a]

Hi.

	A	B
1	8768,1	8768
2	1683,5	1683
3	12345,999	12345

<colgroup><col style="width: 28ptpx"><col width="60pt"><col width="60pt"></colgroup><tbody>
</tbody>

Cell	Formula
B1	=INT(A1)

<colgroup><col style="width: 40ptpx"><col></colgroup><tbody>
</tbody>

I have tried =INT(A1). The result is like this #VALUE!

Many thanks

 

[Vanda_a]

Try:

=RIGHT(A1,LEN(A1)-FIND(",",A1)+1)
=LEFT(A1,FIND(",",A1)-1)

Excel doesn't have the equivalent of VBA's Split function (unfortunately).

Many many thanks.

 

[Matt Rogers]

I have tried =INT(A1). The result is like this #VALUE!

Many thanks

Your column A is text.