Excel help

Say I have this is one cell A1 “123Peter” I want Cell B1 to read “Peter” and take out the 123. What is the formula? Thanks

try the “Left” function =left(). I believe you tell it what character to begin with, say character 4 (4=p) and end at 8 ®. try that.


ah that’s it…does text just do the first number of characters only? No range?

=TEXT() is a formatting function. I believe =MID() falls into the Text category (along with =LEFT(), =RIGHT(), etc…), but it is different from the actual “text” function.

Thanks alpha that worked, Thanks also BigW

Excel is amazing whenever I think I know anything about it there is ten more things I learn.