Nested Formula Help - LEFT and Substitute

Hi,

I am having trouble writing a formula that will limit the text in a cell to 30 characters or less, and remove certain characters like "/". Just to give some background, I need to write this formula because it is messing up my macro. My macro uses the text in this cell (say b4) to rename each worksheet. I think I need to write a =Left($B$4,30) and a =Substitute($B$4,"/","") but I can't seem to combine them. Any help at all would be greatly appreciated!

Try

=Left(Substitute($B$4,"/",""),30)

=left(substitute(b4,"/",","),30)

Thank you!

You're welcome.