Hi All, I need idea's for formatting as seen below, Suggestions and solutions are welcomed Data source Data neededhg_and_formatHGAndFormathg_nothingHGNothinghg_and_empty_to_formatHGAndEmptyToFormat Basically remove "_" underscore and capitalize the first letter and combine them into so. I have been looking for solution all over for a few days , pls assist . Thanks

Data preparation

Hi All,

I need idea's for formatting as seen below, Suggestions and solutions are welcomed

Basically remove "_" underscore and capitalize the first letter and combine them into so.

I have been looking for solution all over for a few days , pls assist .

Thanks

Preparation

Here is how you can do it.

Workflow:

Hope this helps : )

did you tried using Data cleansing tool?

@Pickaxe another method using text-to-column tool

As I have mentioned this can be achieved using a data cleansing tool.

I actually wanted to test if this would truly work 😛

Interesting i am curious on how exactly is it taking HG as title case.

Thanks for the share 😀

Hi @atcodedog05,

I am too tired to check that but we now know that it works 😀

Thanks a lot guys will try out all posted ideas 😊👍