Removing letter from column

[Delivery_Mirdif]

Hii,

I need to remove the first letter (A) and last letter (A) from the column value - A14059417536A
How I can execute this?

[Suvrutt_Gurjar]

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.

help.appsheet.com

SUBSTITUTE()

Text with replacements

[Steve]

Try:

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

help.appsheet.com

LEN()

Number of characters in textual value

help.appsheet.com

MID()

Characters from text