Removing Text from cell range with formula

[Eyespan]

Hello, It wasn't too long ago that I thought I would never be doin
anything with Excel (though it is a very powerful tool) up to now
have been doing mostly web development with VBScript.

I need to be able to delete some text from a range of cells. This is
data integration project.

The cells are a phone number and the data looks like this:
[1] 617-555-5555 654

The above is a result of a concatenation of two cells Phone an
Extension.

=CONCATENATE(D2," ",E2)

I would like to remove "[1]" from the range of cells.

I think this could be accomplished in .asp by using REPLACE function.
How can I do this in Excel?

Thanks in advance,

/mar

 

[Eyespan]

Didn't mean to be talking to myself here. After playing around for
bit found the answer.

=REPLACE(CONCATENATE(M2,N2),1,3,)

Just like in vbscript!

Thanks,

/mar

 

[Frank Kabel]

Hi
try
=TRIM(SUBSTITUTE(A1,"[1]",""))

 

[Eyespan]

That worked too

 

[CLR]

Highlight the column, then > Edit > Replace > type [1] in the "Find what:"
window and leave the "Replace with:" window blank, then > Replace all

Vaya con Dios,
Chuck, CABGx3