Add Column using column from examples.

[Angith_Nair]

Hello team,

I just want to convert values in the form which is shown below...

Here "Column" is a raw column and I want to convert the values like "Custom" column. Basically what I want is If Column has values that are in pattern "T6H5N6" then I want the first 3 characters which will be "T6H" and if the values are purely numeric i.e "235875" then I want that value as it is. Please note that the length of the characters/numbers is 6 which is constant. How can I acheive this in Power Query?
Thanks in advance.

[Fowmy · Accepted solution]

@Angith_Nair 

Add the following as  a Custom Column:

=if Value.Is(Value.FromText([ABC Custom]), type number) then [ABC Custom] else Text.Start([ABC Custom],3)

[Angith_Nair]

Hi @Fowmy ,

That worked....thank you so much...I really appreciate it...