Truncate last five letters on a string

[mrvegas]

I have three cells as follows:

A1: 51150 - Salaries Total
A2: 51170 - Rent Total
A3: 51190 - Utilities Total

I want to have a column adjacent to these cells that removes the word "Total"

Any advice?

 

[barry houdini]

To remove the last 6 characters try this formula in B1

=LEFT(A1,LEN(A1)-6)

 

[mrvegas]

when i type your suggestion I just see the "typed in" formula, it is not returning a string of text?

 

[Dannyh1]

format you cell as number then F2 the cell & enter

 

[mrvegas]

perfect, thanks everyone

 

[Arts]

Hi Barry

with your formula

=LEFT(A1,LEN(A1)-6)

where you have -6 why is it it takes away 6 from the right and not the left, i was expecting that to take 6 letters away from the word salaries