extracting text strings from a cell
Options
System
Employee Admin
This discussion was created from comments split from: Isolating all text to the right of a character (e.g. "-") in a string.
Answers
-
I'm having similar problems with extracting text strings from a cell. I want everything to the left of the @ in an email address and the results are a specific count (8 characters) instead of variable (5-13). What am I doing wrong? When I replace the @ with %40, it returns the entire email address.
=LEFT([Email1]@row, LEN([Email1]@row) - FIND("@", [Email1]@row))
-
@Estelle Redding Try
- =MID([Email1]@row, 1, FIND("@", [Email1]@row) - 1)
If you really only want 8 characters then you just need
- =Left(Email1@row, 8)
of if you only want the 8 characters to the left of the @ then
- =MID([Email1]@row, FIND("@", [Email1]@row) - 8, 8)
-
Thanks, I needed the 5-13 characters to the left of the @ sign. Your first string worked perfectly, thank you, Samuel!
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!