Willowdale
New Member
- Joined
- May 28, 2017
- Messages
- 14
i have a column of data where in many cases, there is an sms shortcut of the form xxxxxxxxxx@txt.att.net.
in this column, it might be the only thing , or it might be appended to other text.
I need a formula to : locate all contiguous characters on either side of the @, and extract that value to another column.
the column may look like:
Fred eats apples for breakfast, rev/col 9999999999@tmomail.net Do not reopen.
or
xmannn see 876543 9999999999@txt.att.net
and I would want the blue text copied and posted in, say some adjacent column.
I looked at extraction forumulae, but I couldn't seem to locate this specific case, esp considering the irregularity of the character spacing.
Thanks listers. Greatly appreciate it. My job requires a lot more excel than it used to.
in this column, it might be the only thing , or it might be appended to other text.
I need a formula to : locate all contiguous characters on either side of the @, and extract that value to another column.
the column may look like:
Fred eats apples for breakfast, rev/col 9999999999@tmomail.net Do not reopen.
or
xmannn see 876543 9999999999@txt.att.net
and I would want the blue text copied and posted in, say some adjacent column.
I looked at extraction forumulae, but I couldn't seem to locate this specific case, esp considering the irregularity of the character spacing.
Thanks listers. Greatly appreciate it. My job requires a lot more excel than it used to.