Removing chracters from cell

jocasta

New member
Joined
Aug 5, 2013
Messages
1
Reaction score
0
Points
0
Hi
I'm wanting to know how I can remove the last 2 characters from a cell but leave the rest of the info in a cell as a number. I have used the remove function and get text left. Eg 1234568t - I want to remove 8t but leave the rest. The formula i'm using is =left(cell number,8). Any ideas?
 
Back
Top