Remove unwanted characters in a cell

[136Village]

Hello all -

I have a spreadsheet that was downloaded from a library software program. The cells have =++ Mot, =+ Roy, (random info in them). I need to cells to state just the letters and need to remove the characters that precede them. I've tried using the 'clean' formula and when I do this, the value that it returns is the cell number.

Does anybody have any suggestions? any help is appreciated.

Thanks!

[Glenn Kennedy]

Can you post a representative sample of the sort of things that yoiu have to deal with? Are there NO letters in the "random" bits?

[alansidman]

Attach a sample worksheet that can be reviewed and analyzed. It is difficult to offer a solution based upon the information provided.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[AlKey]

If unwanted characters always before text try this array formula

=RIGHT(A1,LEN(A1)-(MIN(IFERROR(FIND(CHAR(ROW(A$65:A$122)),A1),""))-1))

...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.

Row\Col	A	B
1	++ Mot	Mot
2	-57Pete	Pete
3	++%+Steven	Steven

[136Village]

Here is a sample.

[AlKey]

Format column A as text, then Ctrl+F type in = in Find, click on Replace button and click on Replace All. Then you can use formula.

or you can simply repeat the process by removing other characters.

[sktneer]

Another way to achieve this is using a macro. Click on the yellow button to run the macro to see if this helps.