text and letters - Concatenate

  • Thread starter Thread starter Manos
  • Start date Start date
M

Manos

Dear all,
couple days ago i have set a query how can use the
concatenate formula

More of you replied and thank you very much

there is a way that i acn take specific characters from a
word?

eg; i have in a cell the word BUDGET
there is a way to make a link with formula to another cell
and take only the B D G in order to show BDG?

Thanks in advance
Manos
 
If you're always substituting for the same word, you can use

=IF(B1="BUDGET","BDG","")

If you always want to delete the letters E, T and U:

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(B1,"E",""), "T",""), "U","")

If you'll have many terms your substituting for, use a Lookup table.


J K
1 BUDGET BDG
2 BUDGERIGAR BGY
3 BUDLIGHT BDL

Then in your formula:

=IF(ISNA(MATCH(B1,J:J,0)),"",VLOOKUP(B1,J:K,2,0))
 
Back
Top