I need to drop the first and last letter. Which I can do but not as slick as I would like to.
=LEFT(A1, LEN(A1)-1)
=RIGHT(A1, LEN(A1)-1)
I do this one at a time. I don't know who to run this formula in one cell.
I have two cells with the same type of problem.
A1
"AUDS"
A2
"Accessibility & Universal Design Services"
I would like them to end up in A3 as Below:
AUDS,Accessibility & Universal Design Services
Note: The two values have a "," between them.
=LEFT(A1, LEN(A1)-1)
=RIGHT(A1, LEN(A1)-1)
I do this one at a time. I don't know who to run this formula in one cell.
I have two cells with the same type of problem.
A1
"AUDS"
A2
"Accessibility & Universal Design Services"
I would like them to end up in A3 as Below:
AUDS,Accessibility & Universal Design Services
Note: The two values have a "," between them.