Try: Upper(Left([Text], 1))
i need the whole word to be changed with this i only get the letter back.
test has to be Test
I have used the function
Replace([Data1]; Left([Data1]; 1); Upper(Left([Data1]; 1)))
What i get is: TesT
Hi,
Please find the attachment and try
Sorry, I misunderstood what you were asking for.
Try: Upper(Left([Data1], 1)) & Right([Data1], Len([Data1])-1)