Forum Discussion

BonnyJH's avatar
BonnyJH
Copper Contributor
May 03, 2024
Solved

Can I split information in a field?

I have a cell that contains this:  00001/  /  /29100/  I would like 2 separate numeric cells, one cell that would contain 00001 and the second cell that contains 29100 omitting the slash marks comple...
excel
  • mathetes's avatar
    mathetes
    May 03, 2024

    You could also employ =CHOOSECOLS(TEXTSPLIT(A1,"/"),1,4) if you have a new version of Excel or subscription to Microsoft 365. This formula has the advantage of working even if the strings of digits vary in length. (If the number of slash marks change, you will need to adjust up or down the final digit to reflect that.)

mathetes's avatar
mathetes
Silver Contributor
May 03, 2024

BonnyJH 

 

Yes it's possible. For general learning in the future, let me refer you to this page of text functions.

 

If ALL of your situations are like this one, 00001/  /  /29100/, consisting of two string of five digits with slash marks in those same positions, a couple very basic functions to yield just the two strings of five digits, one each in a separate cell, would be (with the starting assumption that the original is in cell A1

=LEFT(A1, 5)

and

=MID(A1,LEN(A1)-5,5)  or =LEFT(RIGHT(a1,6),5)

 

  • BonnyJH's avatar
    BonnyJH
    Copper Contributor
    May 06, 2024
    Thankyou!

Resources