So Column W has emails, which occasional have long generated ones like so "guest-XXXXXXXXX"
Other cells have normal emails.
I want to truncate to say 10 characters (or whatever) only the cells with "guest-"
Is this possible? Also must say this column is generated with a formula so that is important to, this is the existing formula in the cell which parses email from another column.
So basically, if the data in the cell from the formula above contains "guest-" I want to truncate to 10 characters.
Please Login or Register to view this content.
(Can you even truncate results into the same cell as the data? Or would it have to go in a new column?)