Your welcome
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"ILoveMyCorgi" wrote:

Thank you so much! Susan

"Mike H" wrote:

Hi,

With your string in A1

=PROPER(A1)

You can then drag down and repaste the new column over the old
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"ILoveMyCorgi" wrote:

I have an Excel file with columns containing for example:
AVILA I am not sure how to change this to Avila
2319 B NORTH OLD HIGHWAY 395 need to change to 2319 B North Old Highway 395

Is there an easy way of doing this? I have over 100 rows with eight columns
I need to change! I hope someone can help me with this. Thank you. Susan