MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Text String Manipulation


Posted by Ryan on August 29, 2000 12:29 PM

Hello,

I have a text string that looks like the following:
0000000000013.52

I need to write a function that will take the "." out of this line so the result would be:
000000000001352


How can I do this?? Any help is greatly appreciated!!

Thanks!

Ryan


Posted by Bill Jelen on August 29, 0100 1:42 PM

If the string is in cell A1, the function would be: =SUBSTITUTE(A1,".","").

Bill