Sérgio Wilker
Reputation: 157
Removing these first strings that are Numbers from Columns?
what is the formula for removing these first strings that are numbers from all columns?
Upvotes: 0
Views: 29
Answers (1)
JNevill
Reputation: 50200
You can use some string functions to pull this off:
=RIGHT(A1, LEN(A1)-FIND(" ", A1))
Upvotes: 1
Related Questions
- to remove text from a sentence in excel after numerics
- Excel Remove text before string for multiple possible strings
- Excel Remove text after string for multiple possible strings
- Removing unwanted numbers after delimiter in Excel
- How do I remove anything that starts with numbers at the end of the text string in VBA?
- Excel formula to extract numbers from string
- Remove all initial numbers from string until non-numerical character is reached
- In Excel Strings that look like numbers in a column need to be interpreted as just a string
- Strip 3 numeric values from string - excel
- Strip characters from a string in Excel