Need to get rid of "[" and "]" from text string.

[RET79]

Hi,

I have file link written like this:

C:WINDOWSDesktopExcel stuff[RHOD1.xls]

I need a worksheet function to just give me:

C:WINDOWSDesktopExcel stuffRHOD1.xls

in another cell.

What is the best way of doing this?

Many thanks

RET79

[Aladin Akyurek]

On 2002-05-18 11:28, RET79 wrote:
Hi,

I have file link written like this:

C:WINDOWSDesktopExcel stuff[RHOD1.xls]

I need a worksheet function to just give me:

C:WINDOWSDesktopExcel stuffRHOD1.xls

in another cell.

What is the best way of doing this?

Many thanks

RET79

=SUBSTITUTE(SUBSTITUTE(A1,"[",""),"]","")

[RET79]

Nice work!

RET79

[Dave Patton]

On 2002-05-18 11:28, RET79 wrote:
I have file link written like this:

C:WINDOWSDesktopExcel stuff[RHOD1.xls]

I need a worksheet function to just give me:

C:WINDOWSDesktopExcel stuffRHOD1.xls

try Substitute

=SUBSTITUTE(SUBSTITUTE(B2,"[",""),"]","")

revise reference as necessary
in another cell.

What is the best way of doing this?

Many thanks

RET79

[Jack in the UK]

A VBA UDF i wrote to do this, uses Jacks Range. Hope you like this i love UDF's

Function Jack_RemvBraces(MyRange As Range) As String
Dim strResult As String
Application.Volatile
If InStr(1, MyRange, "[") <> 0 Then
strResult = Trim(Left(MyRange, _
WorksheetFunction.Search("(", MyRange) - 1))
Else
strResult = MyRange
End If

Jack_RemvBraces = strResult
End Function

Try this function

= Jack_RemvBraces(

then click the insert function to allow Jack UDF input range to be input

MARKER Braces