Googlesheet Blockchain and API balance

[andreadefi]

I wanted to create a spreadsheet (googlesheet) to monitor the balance of some Bitcoin addresses. I inserted this function in a cell:
= IMPORTDATA ("https://blockchain.info/q/addressbalance/3CzAjBqsMJZV4LLL6KSsQWuH4PbDjEaeu7") and it perfectly returns the budget in satoshi.
What I can not do is replace the address with the contents of the cells where the other addresses are, eg:
= IMPORTDATA ("https://blockchain.info/q/addressbalance/B2"), I tried different systems, like (B2) &B2, etc. but I can not find the correct format to insert the reference to the cell instead of the address.
If anyone can help me, thank you

[starmyc]

Hello,

Did you try CONCATENATE ?

The following works:

Code:

= IMPORTDATA (CONCATENATE("https://blockchain.info/q/addressbalance/",J24))

(with your address in J24, in this case)