In Cell B3, I have "ABC-DEF",
In Cell C3 I have "DEF-ABC"
In Cell D3, I want "ABC-DEF-ABC". Is there any formula that can achieve this?
In Cell B3, I have "ABC-DEF",
In Cell C3 I have "DEF-ABC"
In Cell D3, I want "ABC-DEF-ABC". Is there any formula that can achieve this?
Try:
=LEFT(B3,4)&C3
Last edited by Armando Montes; 04-22-2013 at 10:58 AM.
Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks