Delete 1st and Last character of the Text

[saumyashah90]

I have column

Header 1
, Saumya,
,Raj,Peter,
,Peter,
Peter
,Raj,Saumya,Peter,
Sam
,Sam,Peter,Raj,

I need output as:

Saumya

Raj,Peter

Peter

Raj,Saumya,Peter

Sam

Sam,Peter,Raj

Can you help me in this?

[jonathandienst]

This will remove the first an last character:

     =Substr([Header 1], 2, Len([Header 1]) - 2)

You may also want to Trim() this:

     =Trim(Substr([Header 1], 2, Len([Header 1]) - 2))

HTH

Jonathan

[Anonymous]

mid(yourstring,2,len(yourstring)-2) should work

[saumyashah90 · Accepted solution]

=Left(Right(TEAM,Len(TEAM)-1),Len(TEAM)-2)

This worked

[saumyashah90]

Thanks Jonathan this works too

[saumyashah90]

Thanks this works too