Microsoft Office Forums - View Single Post - [Solved] vbc code

Thread: [Solved] vbc code

View Single Post

Old

09-13-2011, 02:16 PM

Colin Legg Colin Legg is offline

Colin Legg is offline

Colin Legg uses Windows 7 32bit

Windows 7 32bit Colin Legg uses Office 2010 32bit

Colin Legg uses Office 2010 32bit

Office 2010 32bit

Expert

Join Date: Jan 2011

Location: UK

Posts: 369

Colin Legg will become famous soon enough

Default

Hi,

You probably don't need VBA for this.

If RAJ PETER is in cell A1, then this formula will return Raj Peter

=PROPER(A1)

Is that something you can work with?

Reply With Quote