CODEWITHSUNDEEP
regexgoogle-sheetsgoogle-sheets-formula
Alan Saydon
Alan Saydon

Reputation: 11

Split function Issue

I have a rather simple question however I cannot seem to find the issue.

I am using the below Split function, however, when I have an account number leading with 0 it automatically deletes the zero as it is interpreted as a number, not as text, however I have tried implementing to text function but as account number vary in sizes and not standard then I might have some accounts with more 0 than it supposed to have. I have also tried other ways however nothing seems to work.

Does anyone have a solution for this?

Code using:

=SPLIT(A2, "Account Number: ")

Upvotes: 0

Views: 46

Answers (1)

player0
player0

Reputation: 1

you will need to use regex:

=REGEXEXTRACT(A1, "Account Number: (.*)")

0

or:

=SUBSTITUTE(SPLIT(A1&"♥", "Account Number: "), "♥", )

0

Upvotes: 1

Related Questions