Hi All, Good Day!
In Excel i have the column name called as “Unit”. In that column i have multiple row values like as “A0123456789” & “0123456789"combined with alpha Numeric and numeric value. If the value is Numeric i want add the letter like as “0123456789:AA”, if it,s alpha Numeric need add letters " A0123456789:BB” for entire column.
Also in the same excel i have Date column with format of “dd/mm/yyyy”. I want to convert it to “dd.mm.yyyy” for entire column. Kindly advise how can i do it.