I've got a really annoying problem at work that occurs in a lot of our
data. Our store numbers are usually embedded within a longer string of
text. Something like "Your town 000345 Anyplace ABC." Sometimes there is
a # before the data, but not always, so a simple text to columns won't
work.
In a search for efficiency, I came across this site.
Basically, it's a formula that searches for the first number and
returns the position of that first number. Then, you can use that
information to return all characters to the right (when, combined with a
LEFT function can get me the six digit store number I need). This has
saved me so much time.
https://exceljet.net/formula/split-text-and-numbers
Search terms and phrases:
Isolating text from numbers in Excel
Separating numbers from text Excel
Return numbers in middle of text string
No comments:
Post a Comment