Excel help

CFA General
#1

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

#2

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.

#3

=mid(A1,4,5)

#4

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

#5

=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.

#6

Thanks alpha that worked, Thanks also BigW

#7

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