hobbiton73
01-16-2013, 09:48 AM
Hi, I wonder whether someone may be able to help me please.
I have been trying to find a solution to this all day online, but I just can't find the answer.
One of the cells (column R) contained within a dynamic form which I've built, allows users to enter their managers name and as you can imagine the results differ in repect of the formats used.
To try and insure a uniformed entry I'd like to have to apply the following format to the cell:
'First Initial' then '.' then the 'Surname'. So for example 'John Smith' would become 'J. Smith'.
Could someone perhaps offer some guidance on the syntax I ned to use for the cell format to achieve this?
Chris
I have been trying to find a solution to this all day online, but I just can't find the answer.
One of the cells (column R) contained within a dynamic form which I've built, allows users to enter their managers name and as you can imagine the results differ in repect of the formats used.
To try and insure a uniformed entry I'd like to have to apply the following format to the cell:
'First Initial' then '.' then the 'Surname'. So for example 'John Smith' would become 'J. Smith'.
Could someone perhaps offer some guidance on the syntax I ned to use for the cell format to achieve this?
Chris