Forum Discussion
Convert list of addresses
This is a 2 steps request. First, I want to select and input a list of addresses (of values, not text) into a cell like this a3,b5,d55,k20 and have it display exactly like that. Not as a value o...
Patrick2788 I agree and suggest as much also.
JG_Berson as for more simple formula it turns out INDIRECT might work on an array (it originally failed for me but I think that was because I had to add the TRIM). So here is a more simple formula but still won't work for you:
=MAX(INDIRECT(TRIM(TEXTSPLIT(G1,","))))but using the old trick to go from text to array may work for you but you will probably have to enter the formula using CTRL-SHIFT-ENTER:
=MAX(INDIRECT(TRIM(MID(SUBSTITUTE(G1,",",REPT(" ",LEN(G1))),(ROW($A$1:INDEX($A:$A,LEN(G1)-LEN(SUBSTITUTE(G1,",",""))+1))-1)*LEN(G1)+1,LEN(G1)))))I'll cross my fingers for you.
Thanks, please uncross fingers.
While that should work, it is far too complex to use. I would need hundreds of instances in my spreadsheet.
Please refer to my reply to Patrick2788 as to what I am trying to do.
While that should work, it is far too complex to use. I would need hundreds of instances in my spreadsheet.
Please refer to my reply to Patrick2788 as to what I am trying to do.