CODEWITHSUNDEEP
stringgoogle-sheetsgoogle-apps-scriptsplit
amrita
amrita

Reputation: 45

How to separate alphanumeric values and numeric values from coulmn of googlesheet?

I am working on googlesheet in which id has values both numeric and alphanumeric.I want numeric values in other column and alphanueric values in separate column.

<table>
<thead>
<tr>
<th>    ID    </th>
<th>    Amount    </th>
</tr>
</thead>
<tbody>
<tr>
<td>    2025010121474784006559939    </td>
<td>    944.78    </td>
</tr>
<tr>
<td>    387cd23a72c049dc81fcfdea4882c76c    </td>
<td>    1940    </td>
</tr>
<tr>
<td>    2025010123331559557464480    </td>
<td>    1940    </td>
</tr>
</tbody>
</table>

Upvotes: -2

Views: 51

Answers (2)

TheMaster
TheMaster

Reputation: 50462

FILTER the data using :

=FILTER(A2:A4,REGEXMATCH(A2:A4,"[^0-9]"))
  • ^ - Not
  • [0-9] - a 0 to 9 character

For the inverse,

=FILTER(A2:A4,NOT(REGEXMATCH(A2:A4,"[^0-9]")))

Upvotes: 0

doubleunary
doubleunary

Reputation: 18809

Use wraprows(), split() and regexreplace(), like this:

=wraprows(split(regexreplace(join("", A2:A), "<.+?>", "→"), "→ "), 2)

screenshot

See wraprows(), split() and regexreplace().

Upvotes: 0

Related Questions