PC Review


Reply
Thread Tools Rate Thread

capitalize first letter

 
 
rodchar
Guest
Posts: n/a
 
      20th Nov 2008
hey all,
is there an easy way to capitalize just the first letter in a column and
leave the rest as is?

for example,
pubID --> PubID

thanks,
rodchar


 
Reply With Quote
 
 
 
 
Bernd P
Guest
Posts: n/a
 
      20th Nov 2008
Hello,

You might want to use
=UPPER(LEFT(A1,1))&MID(A1,2)

but maybe
=PROPER(A1)

will also work for you.

Regards,
Bernd
 
Reply With Quote
 
Jim Thomlinson
Guest
Posts: n/a
 
      20th Nov 2008
This formula should do it for you...

=UPPER(LEFT(A1, 1)) & MID(A1, 2, 256)
were the text is in A1
--
HTH...

Jim Thomlinson


"rodchar" wrote:

> hey all,
> is there an easy way to capitalize just the first letter in a column and
> leave the rest as is?
>
> for example,
> pubID --> PubID
>
> thanks,
> rodchar
>
>

 
Reply With Quote
 
galimi
Guest
Posts: n/a
 
      20th Nov 2008
=UPPER(LEFT(A1,1)) & RIGHT(A1,LEN(A1)-1)

Assuming the data you want to capitalize is in column A
--
http://HelpExcel.com
(E-Mail Removed)



"rodchar" wrote:

> hey all,
> is there an easy way to capitalize just the first letter in a column and
> leave the rest as is?
>
> for example,
> pubID --> PubID
>
> thanks,
> rodchar
>
>

 
Reply With Quote
 
rodchar
Guest
Posts: n/a
 
      20th Nov 2008
thanks everyone for the help,
rod.

"rodchar" wrote:

> hey all,
> is there an easy way to capitalize just the first letter in a column and
> leave the rest as is?
>
> for example,
> pubID --> PubID
>
> thanks,
> rodchar
>
>

 
Reply With Quote
 
Mike H
Guest
Posts: n/a
 
      20th Nov 2008
Hi,

Do it in the same column with a macro. Right click your sheet tab, view code
and paste this in and run it.

Sub versive()
Lastrow = Worksheets("data").Cells(Rows.Count, "A").End(xlUp).Row
For Each r In Worksheets("data").Range("A1:A" & Lastrow)
If Not r.HasFormula Then
r.Value = UCase(Left(r.Value, 1)) & Mid(r.Value, 2)
End If
Next
End Sub

Mike

"rodchar" wrote:

> hey all,
> is there an easy way to capitalize just the first letter in a column and
> leave the rest as is?
>
> for example,
> pubID --> PubID
>
> thanks,
> rodchar
>
>

 
Reply With Quote
 
Dave Peterson
Guest
Posts: n/a
 
      20th Nov 2008
One more...

=UPPER(LEFT(A1, 1)) & lower(MID(A1, 2, len(a)))



rodchar wrote:
>
> hey all,
> is there an easy way to capitalize just the first letter in a column and
> leave the rest as is?
>
> for example,
> pubID --> PubID
>
> thanks,
> rodchar


--

Dave Peterson
 
Reply With Quote
 
Dave Peterson
Guest
Posts: n/a
 
      20th Nov 2008
Ignore my suggestion. I didn't read the question.

rodchar wrote:
>
> hey all,
> is there an easy way to capitalize just the first letter in a column and
> leave the rest as is?
>
> for example,
> pubID --> PubID
>
> thanks,
> rodchar


--

Dave Peterson
 
Reply With Quote
 
rodchar
Guest
Posts: n/a
 
      26th Nov 2008
thanks all for the help,
rod.

"rodchar" wrote:

> hey all,
> is there an easy way to capitalize just the first letter in a column and
> leave the rest as is?
>
> for example,
> pubID --> PubID
>
> thanks,
> rodchar
>
>

 
Reply With Quote
 
nflor009
Guest
Posts: n/a
 
      19th Dec 2008
A follow up question on this topic:

How do I format a cell so that whatever is entered has the first letter
capitalized, as in a proper name. I tried the =PROPER(cell) but a formula
doesn't work since you delete it when you type into that cell, so I need
formatting, not a formula.

"rodchar" wrote:

> hey all,
> is there an easy way to capitalize just the first letter in a column and
> leave the rest as is?
>
> for example,
> pubID --> PubID
>
> thanks,
> rodchar
>
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Capitalize first letter of each word TapouT Microsoft Word Document Management 3 28th Sep 2009 03:21 AM
Capitalize first letter =?Utf-8?B?RExSX0dyYXBo?= Microsoft Access Forms 4 20th Jun 2007 07:24 PM
Capitalize first letter cmichaud@ufl.edu Microsoft Access Forms 7 14th Apr 2006 01:09 PM
Capitalize the first letter Chi Microsoft Excel Misc 5 18th Sep 2004 12:35 AM
CAPITALIZE FIRST LETTER OF EACH WORD =?Utf-8?B?Vmlj?= Microsoft Access Form Coding 6 15th Jun 2004 11:39 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:48 PM.