# Excel data return

If I want to lookup row 3 column "amz" and the end result will be side by side, how do i do that Example: a=.4 m=.91 z=.22
input; amz
output: .4.91.22

phinds
Gold Member
Don't know how you would do it in Excel formulas but here's how you do it in VBA (as an example)

I've put the kind of strings you show into 3 consecutive cells:

Then created a VBA macro:
Code:
Sub string1()
Dim a As String
a = Cells(2, 4)
MsgBox Cells(2, 4) & Cells(2, 5) & Cells(2, 6)
End Sub
and the result is ".1.2.3"

Svein