- Joined
- Jul 13, 2010
- Messages
- 1
- Reaction score
- 0
Hello,
Currently, I have a set of phone numbers on one column.
On another column, I would like only the first 6 digits displayed.
Like this,
(abc) def-ghij --> abcdef
Is this possible? I tried commands like =trunc and =--left but it did not work.
Thanks in advanced!
Currently, I have a set of phone numbers on one column.
On another column, I would like only the first 6 digits displayed.
Like this,
(abc) def-ghij --> abcdef
Is this possible? I tried commands like =trunc and =--left but it did not work.
Thanks in advanced!