Excel Tips - Remove Non Numeric Characters

Hello,

Very new to Excel. In fact, this is the first time I have ever really used it and I have gotten this far in about the last 30 minutes:

Code:

=CONCATENATE(N13,"_","take",O13,"_","cam",I13)

I am under a lot of pressure here to create a Macros to change a column in what's called an .ALE file. I could really use some help and I think it would be pretty easy for people here. What I need to do is take the above formula and remove any numeric characters from just the last value, "I13". Then, I need to make that formula into a macros that will operate on an indeterminate number of rows starting with row 13. Can anyone help me?

I really appreciate any help!

Hi

I Need a excel macro which has to find the non numeric values in the column (G:G) and delete the entire row,kindly help

Regards
Sathish V

Hi, Can anybody help?? im trying to remove all non numeric characters from a cell.

for example, i want to turn "234k324@34.34?>)(" into "2343243434"

Greetings,

Without using vba code and using a builtin function/sql code is it possible to remove all non numeric characters from a text field?

So far I've read about the val function which isn't up to the tast and attempted to use replace as follows (which doesnt work)

e.g. Replace([Field1], [A-Z], "").l

Can this be done?

Thanks
Rob

I am looking for a formula to remove special characters (like ' , " & - ) in a sheet.
Thank you.

hi,

i have a excel file in which i have some specail characters like a box after every word which i need to remove manually in order to format the entire file.............is there way in excel that we can remove it in one shot or macro or some thing which might help me..............

regards,

All my values within column A are separated by a dash. I'd like column B to continuously copy column A with the exception of the characters after the dash. example:

____A_____________B
12345-456_______12345
22456-333_______22456
1553665-45______15553665

How can I format cell B to constantly reproduce this result?

Thanks
Ocean

Is there an excel function that can remove all special characters ~`!@#$%^&*()_-+=|\{}[]:;"'<,>.?/ and hard return ascii characters. I have been doing a control find and then replacing it with a space. If this can be done faster or maybe a macro created that would be great. IS anyone familiar with this?

Thanks a lot!!!!

Is there a single command/formula to remove the first 3 letters in each of
the fields in an entire column?

Hi, can anyone advise me how to remove unwanted characters such as comma, space etc. from an excel sheet. Please see a sample below.
2, 2, 3, 2, 1, 3, 2, 1, 1, 3, 1, 1, 1, 3, 2, ,1 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,