Find alpha all characters

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
Is it possible to use Find Find /Replace to find all the letters in a range?
Thanks
 
I think you'd need a macro. Excel's Find is a pretty blunt instrument.

--
Jim
| Hi,
| Is it possible to use Find Find /Replace to find all the letters in a
range?
| Thanks
 
iliace

I have imported times from a database that have single letter extensions
e.g. 00:00a

The extensions are all different letters and I want to find and replace them
with a blank to make the times workable in excel formulae.
 
David,
Thanks for this - the formula works perfectly.
I was hoping to use the find/repalce tool as then I wouldn't have to change
the layout of the imported data but alas this doesn't appear to be an option.
Thanks again
 
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

Wildcards in If statements 4
Extract alpha from a cell 1
Lookup...find next 5
Find and Replace variable string 11
Format Cell - Only Upper Case Alpha characters 3
My alpha keys are not working. 1
Alpha with numeric and numeric only numbers in a column 6
I want to eliminate the first character in several lines 7

Back
Top