Dear all, How can do that?
A1= ABCDEFG B1=CD Which formula i need to use to have in C1 ABEFG?
Hi,
Please try the expression given below in the Column C
CONCATENATE(LEFT([ColumnA],(FIND([ColumnB],[ColumnA])) - 1 ),RIGHT([ColumnA],( 6
Hope this helps.
The above expression assumes that you have a character string of 7 characters in Column A and Column B always has 2 continuous characters as youhave given in sample ,such as AB,BC,CD etc.
How about SUBSTITUTE(SUBSTITUTE([A1],LEFT([B1],1),""),RIGHT([B1],1),"")
User | Count |
---|---|
42 | |
32 | |
24 | |
23 | |
14 |