LinkBack URL
About LinkBacks
Hi,
I need your help to remove the DOT & COLON (Special Charecters) in "0015.6053:BC2C"
Regards,
Humac Deep
Hi,
I need your help to remove the DOT & COLON (Special Charecters) in "0015.6053:BC2C"
Regards,
Humac Deep
Last edited by pike; 01-14-2012 at 04:07 PM. Reason: characters
Did you try a normal Find -> Replace? Find . and replace with nothing (do not type anything in the replace box).
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Hi Arlette,
Yes, I have tried it. The data is in 1500 rows and few of them changed to 1.32E+145.
Regards,
Humac
Hi Humac
Must exists a shorter formula, but this works for me.
=SUM((MID(0&A1;LARGE(IF(ISNUMBER(MID(0&A1;ROW($1:$256);1)*1);ROW($1:$256);1);ROW($1:$256));1)*1)*10^(ROW($1:$256)-1))
yOUR DATA IN a1.
hOPE TO HELPS YOU.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
thats a problem! try =SUBSTITUTE(SUBSTITUTE(A1,":",""),",","") instead then copy paste back as special values to remove the formula
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Array formula(CSE)!
Hello,
Fotis - I have tried and it doesn't work for me.
Martin - Thanks for your formula it works..
Regards,
Humac
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks