Converting upper case to lower case

  • Thread starter Thread starter ILoveMyCorgi
  • Start date Start date
I

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
 
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
Click to expand...

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
 
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.
 
Thank you so much! Susan

Mike H said:
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.
Click to expand...
 
Your welcome
--
Mike

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