text is imported, and regular, as in 4 digits with a letter appended. So, I could separate the cell into two cells of a certain number of characters, I could perhaps recognize text and separate it or delete it from a cell. I know Excel can do this, I think based on the number of characters in the cell....
thanks for anyone who can help!
MacBook Pro (2017 – 2020)
nelsolot wrote:
text is imported, and regular, as in 4 digits with a letter appended.
If the text in, say, cell B2, is always 4 digits followed by a letter, then you could use
=LEFT(B2,4) to retrieve the digits, and
=RIGHT(B2,1) to retrieve the letter.
If there may be more or fewer than 4 digits (i.e., the text is not regular) then you could use:
=REGEX.EXTRACT(B2,"\d+") to retrieve the digits
Use ; instead of , in the formulas if your region uses , as a decimal separator.
SG
nelsolot wrote:
text is imported, and regular, as in 4 digits with a letter appended.
If the text in, say, cell B2, is always 4 digits followed by a letter, then you could use
=LEFT(B2,4) to retrieve the digits, and
=RIGHT(B2,1) to retrieve the letter.
If there may be more or fewer than 4 digits (i.e., the text is not regular) then you could use:
=REGEX.EXTRACT(B2,"\d+") to retrieve the digits
Use ; instead of , in the formulas if your region uses , as a decimal separator.
SG
how to extract text from a cell in numbers for Mac v. 11.2
