Need a function or some VB code

[allwork]

I need a function to DELETE the rightmost characters from a cell.
RIGHT won't do it - I want to get RID of the rightmost characters, and
LEFT won't work because each cell varies in the number of leftmost
characters. I will need to delete the same number of rightmost
characters, e.g., seven characters.

I am trying to remove the blank space and five-digit item number from
cells containing an item description and its item number.

Anyone have any ideas?

Thanks

 

[Harlan Grove]

I need a function to DELETE the rightmost characters from a cell.
RIGHT won't do it - I want to get RID of the rightmost characters, and
LEFT won't work because each cell varies in the number of leftmost
characters. I will need to delete the same number of rightmost
characters, e.g., seven characters.

=LEFT(x,LEN(x)-7)