Removing letter from column

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.

2 Likes

Try:

MID([Column], 2, (LEN([Column]) - 2))


1 Like