Converting upper case to lower case
 

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

Converting upper case to lower case
 

On 21 Jan, 14:46, 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

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

Converting upper case to lower case
 

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

Converting upper case to lower case
 

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

Converting upper case to lower case
 

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