I would like cell A2 to look at cell A3 and repeat the same value but without the dash. A3 may be the result of a formula if that matters.
For example, A3 will say 1234-56 which would make A2 say 123456. The only 2 formats that would come into play are 1234-56 and 1234-567. I'm still learning about the difference in how text and numbers are treated in different formulas. I believe these would all be text. Out of curiosity, would the output be text then too?
Edit - If I use MID I can get the results I need by being specific, but when I try to add SEARCH to it to find the dash it doesn't word for me.
Another edit (because I do try to figure it out on my own, I don't just post).
I can use =MID(A3,1,4)&RIGHT(A3,LEN(A3)-4) which works!!! Yay me for figuring it out on my own.
Thank you.
Bookmarks