o******6
发帖数: 538 | 1 ☆─────────────────────────────────────☆
spidey (蛛蛛侠) 于 (Wed Mar 5 11:41:42 2008) 提到:
If I want to keep part of a string, I would use substr(var,n,m) in SAS.
But how can I do the same thing in a cell in Excel?
Thanks.
☆─────────────────────────────────────☆
papertigra (长工胖头猪) 于 (Wed Mar 5 11:56:28 2008) 提到:
可以用Left, right function
Left(A3,4)
☆─────────────────────────────────────☆
spidey (蛛蛛侠) 于 (Wed Mar 5 12:49:51 2008) 提到:
Great! Thanks!:D
btw, what if in the middle of a cell? |
|
