Converting upper case to lower case

[ILoveMyCorgi]

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

 

[Brett]

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

You can use the PROPER function. If your address is in Cell A1, you
would use:

=PROPER(A1)

You can then drag the formula for the 100 rows.

Brett

 

[Mike H]

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]

Thank you so much! Susan

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.

 

[Mike H]

Your welcome
--
Mike

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