Urgent

  • Thread starter Thread starter aducutlas
  • Start date Start date
A

aducutlas

Need formula to remove character from a string and display string in
new cell...

e.g

123/adc-123 xyz 123abc123xy
 
Hi
try the following
=SUBSTITUTE(A1,"-","")
A1 stores your sorce text. The above removew the '-' from your text
HTH
Frank
 
Hi Frank



=SUBSTITUTE(SUBSTITUTE(A1,"/",""),"-","")


This is close but I need to remove one more charater...".
 
Try
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"/",""),"-",""),".","")

Frank
 
You must log in or register to reply here.

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

CSV files and having numbers and strings in there... 9
If ActiveCell has a comment then exit sub 22
Match based on a lookup and then flag 4
Formatting Macro Issue 2
Inserting an image 6
Close Match 5
Excel VBA question referencing previous cell until value found 0
Put data by matching cell value with sheet name 2

Back
Top