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

Hello,

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

but maybe
=PROPER(A1)

will also work for you.

Regards,
Bernd

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
>
>

=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
>
>

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
>
>

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
>
>

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

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

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
>
>

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
>
>