Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
mid(yourstring,2,len(yourstring)-2) should work
=Left(Right(TEAM,Len(TEAM)-1),Len(TEAM)-2)
This worked
Thanks Jonathan this works too
Thanks this works too