Formula to change text format to BLOCK CAPITALS

  • Thread starter Thread starter Georgeina
  • Start date Start date
G

Georgeina

I have created a spreadsheet to record names of guests invited to an
event, with a yes/no drop down list [column B] to record their response
to the invitation.

I want to create a formula which will convert their name [columns D &
E] to BLOCK CAPITALS if I record a 'yes' response. I don't know how to
make this happen, beyond knowing I have to write some kind of formula.
Please help!
 
Georgeina said:
I have created a spreadsheet to record names of guests invited to an
event, with a yes/no drop down list [column B] to record their response
to the invitation.

I want to create a formula which will convert their name [columns D &
E] to BLOCK CAPITALS if I record a 'yes' response. I don't know how to
make this happen, beyond knowing I have to write some kind of formula.
Please help!
Click to expand...

Take a look at the UPPER function. For example:
=UPPER(A1)
 
Homework or coincidence?
Sub makeupper()
For Each c In Range("a1:a10")
c.Value = UCase(c)
Next
End Sub
 
Georgina

Why block capitals?

If just to highlight the names with a Yes in Column B it would be easier to
highlight them as Bold Underlined or a nice color.

Select cells with guests in column D and Format>Conditional
Formatting>Formula is:

=B1="yes"

Format as you wish using examples above. OK your way out.

Select cells in Column E and repeat.

Gord Dibben XL2002
 
Back
Top