PROPER should do it ..
Assuming data in A1 down, eg:
Lorena & james
In B1, copied down: =PROPER(TRIM(A1))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"dberger16" wrote:
Hi,
here is an example of data in my column:
Lorena & james
i simply want to capitize the J (james).
Thanks for your assistance
DaveB