Hii,
I need to remove the first letter (A) and last letter (A) from the column value - A14059417536A
How I can execute this?
In general SUBSTITUTE() function should work. Please take a look if it helps.
An expression something like SUBSTITUTE([Column Name],โAโ,"")
Here [Column Name] contains the original text string having 2 "A"s, that is โA14059417536Aโ
Please post more details if you are looking at something else.
Try:
MID([Column], 2, (LEN([Column]) - 2))
User | Count |
---|---|
41 | |
36 | |
30 | |
23 | |
16 |