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

  • Thread starter Thread starter Paul Richards
  • Start date Start date
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?
 
Paul,

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

You could just try Replace (CTRL+H).

Find What = [
, click Replace All.

Repeat for ]

Rgds,
Andy
 
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...
 
Back
Top