CODEWITHSUNDEEP
stringexcelexcel-formula
AJ.
AJ.

Reputation: 2569

String manipulation in Excel sheet formula

Cell A4 has latitude and longitudes like this 33.7998709,-84.3432666.

I want cell A5 should have getMap(33.7998709,-84.3432666);

Please see attached image.

enter image description here

But I am getting #VALUE! error!

How can I get this formatted string in the cell next to A4?

Upvotes: 1

Views: 459

Answers (1)

Pepe
Pepe

Reputation: 6480

In cell A5

=CONCATENATE("getMap(",A4,");")

Upvotes: 3

Related Questions