How to split the text values in Excel by comma
How to split the text values in Excel by comma
Let us Discuss that how we can separate the two values in an excel sheet.
Description: Excel sheets can be used with Multiple formulas to provide a specific report
Syntax:
The syntax for splitting the values of a single column into two different columns is given as below :
=LEFT(C2, SEARCH(",",C2,1)-1)
For example :----
We have the table with a column name Value and we want to separate these two values where a comma is there between two values.
ID
|
Count
|
Values
|
Value1
|
Value2
| ||||
7.39989E+11
|
2
|
1942704,1942704
|
1942704
|
1942704
| ||||
4.01321E+11
|
2
|
176161, 422407
|
176161
|
422407
| ||||
4.80284E+11
|
2
|
720662, 2621902
|
720662
|
2621902
| ||||
4.81108E+11
|
2
|
333610, 2512065
|
333610
|
2512065
| ||||
The DIY image is given below :--
So to separte the Column no three which is with name Values we will have to write broth side :--
- One for Right side Separation Excel sheet value
- Second is Left Side Separation Excel sheet value
So for both side above is the example given.
0comments
Post a Comment