Is there an Excel Function that is the Reverse of RIGHT()

[nodsdorf]

Hi all, my first post here and I'm looking for some help.

I need to copy data from cell A1 to cell B1 "Except" for the last 4 characters. I'm looking for a function that can do this and drag down for the entire column B. I can't use LEFT() because the length of the left changes, but the RIGHT 4 will always be the same.

Example
Column A
Apple-90T
Banana-90T
Lime-90T

Output I would like in column B
Apple
Banana
Lime

Which I think is basically the reverse of RIGHT(A1,4)

Any help is very much appreciated.

[ron2k_1]

Please Login or Register  to view this content.

[SteveG]

Hi,

The LEFT function is what you need in conjunction with the FIND function to determine the number of characters to return.

=LEFT(A1,FIND("-",A1,1)-1)

HTH

Steve

[nodsdorf]

Thank you Ron & Steve,
Both answers work perfectly.

[icestationzbra]

if the last four characters are always the same, this will work too:

=SUBSTITUTE(A1,"-90T","")

[nodsdorf]

Thank you Ice, that works as well.

The solution I have used in the past was adding columns and splitting it on the dash with text to columns. Then copy&pasting data back. In this case I needed to append some additional information so these solutions are perfect.

Thanks again all 3