Issues with Normalized name Formula: Empty Rows and Uppercase Names

Hey there, got a problem with a "Normalized name" formula: I've shared my prompt. My problem is that i get a lot of empty rows, + some of the names are still full uppercase like JENNIFER. When i prompted it to NEVER do that. what have i done wrong? Company tabe: https://app.clay.com/workspaces/261880/workbooks/wb_JxZfE3e8m6gM/tables/t_3YYgd98KZ2Gz/views/gv_U5odt54FNxEY

Gautam K.
·
·
what is the formula showing up below after you click on Generate formula
Gautam K.
·
·
this works fine
Amir D.
·
·
thx!
Gautam K.
·
·
for empty rows you may need to check if you got space in front of name
Tanvi R.
·
·
Hey Amir, thanks for reaching out! Appreciate you jumping in Gautam to support here. I just checked your Normalized name formula column Amir and it looks like its running successfully, great job on your revised prompt! Is there anything else I can help you with?
Channeled
APP
·
·
Hey there - just wanted to check in here to see if you needed anything else! Feel free to reply back here if you do.
Channeled
APP
·
·
We haven't heard back from you in a bit, so we're going to go ahead and close things out here - feel free to let us know if you still need something!
Channeled
APP
·
·
Hi Amir D.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: