nested functions ?

[bastienk]

Hi All

trying to capture a portion of a cell where i need to split that cells data based on a comma

tried using:

=TRIM(LEFT(Z1729,SEARCH(Z1729,",")))3

and

=TRIM(MID(Z1729,0,SEARCH(Z1729,",")))

but it doesn't work...

Any hints would be appreciated...

TIA




Bastien

Cat, the other other white meat

 

[TonyGroves]

How about:
[tt]
=TRIM(LEFT(Z1729;SEARCH(",";Z1729)))
[/tt]

-----
=SUBSTITUTE("world";"war";"peace")