I need to create Value IDs from text data that isn't always the most helpful. My company is using Excel and SQL currently.

I have "BTA Canvas Taupe (#5461-0000)" and I need to create formulas to have "A.5461-0000". Currently I have this:

```
=CONCAT(MID(A6,3,1),".",IF(TRIM(CLEAN(IFERROR(RIGHT(A6,LEN(A6)-SEARCH("#",A6)),A6)))="",A6,TRIM(CLEAN(IFERROR(RIGHT(A6,LEN(A6)-SEARCH("#",A6)),A6)))))

```

It returns `A.5461-0000)`

How to get that last ")" off?