Trying to strip characters from beginning and end of a text string of variable length

P

Paul Richards

Hi all...Great newsgroup this...Please can I ask a newbie question?

I have a list like this

[John Jane Peter Anne James]
[Peter Anne James]
[Jane Peter John]

I'm trying to strip out the "[" character and the "]" for each row,
and I'm afraid I'm stuck...!

Sorry, but I'm a real newbie here...
Is there any advice on how to do this?
 
B

Bob Phillips

Paul,

Assuming A1 down, in Bq1 put this formula
=SUBSTITUTE(SUBSTITUTE(A1,"[",""),"]","")
and copy down all rows
 
A

Andy Brown

"Paul Richards",

You could just try Replace (CTRL+H).

Find What = [
, click Replace All.

Repeat for ]

Rgds,
Andy
 
D

Debra Dalgleish

You can use the Replace command:

1. Select the cells that you want to change
2. Choose Edit>Replace
3. Find: [
4. Replace with: (leave this blank)
5. Click Replace All
6. Find: ]
7. Replace with: (leave this blank)
8. Click Replace All


Paul said:
Hi all...Great newsgroup this...Please can I ask a newbie question?

I have a list like this

[John Jane Peter Anne James]
[Peter Anne James]
[Jane Peter John]

I'm trying to strip out the "[" character and the "]" for each row,
and I'm afraid I'm stuck...!

Sorry, but I'm a real newbie here...
Is there any advice on how to do this?
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Importing parts of a text file into Excel 4
Stripping characters... 1
Reomving a set numer of characters from a text string 3
Formula to strip figures from cells text strings 5
Access Pulling a variable length string in MS Access 0
Replace or insert characters in text string 6
Lambda 3
Extract characters from Right of string 5

Top