Trim Function

[Rick__]

Hi,

Could someone help me or point me in the right direction, I have this formula

=LEFT(MID(A1,FIND("/",A1)+1,LEN(A1)),FIND("/",MID(A1("/",A1)+1,LEN(A1)))-1)

It extracts the middle part of:

1113987 / TBA / Apples

So the result will be

TBA

However I have a number of these which sometimes have a space before the TBA and sometimes not.

I would like to use the TRIM function in the formula to remove these spaces as part of the formula, but am having difficulties trying to figure out were to insert it into the formula.

 

[Joe4]

Your formula does not work, it is returning errors saying that it does not have enough arguments.
Are you sure that you copied it correctly?

When you getting it working, you should be able to wrap the whole thing in TRIM, i.e.

=TRIM(formula)

 

[Rick__]

I did what you said and just wrapped it in the TRIM formula and it has worked perfectly

=TRIM(LEFT(MID(A2,FIND("/",A2)+1,LEN(A2)),FIND("/",MID(A2,FIND("/",A2)+1,LEN(A2)))-1))

Thank your for your help with this

 

[Joe4]

You are welcome!