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

Array counting 3
Importing parts of a text file into Excel 4
Replace or insert characters in text string 6
Extract characters from Right of string 5
Search string beginning at the end 2
selecting the last letter in a string 2
VBA Formula Help 10
Seperating a variable length string 5

Top