Ok, got one for ya. I want to take multiple text items that are in one cell seperated by a comma and have them be split into a different cells somewhere else on the spreadsheet.
heres the catch though, i need it to be able to update itself, so Text to Column doesnt work.
if i have "car , plane, boat" in A1 and i have those three split into B1:B3, i need to be able to go back later and change plane to helicopter and have B2 automatically change.
guess its kinda like a reverse concancacancnantnantanc-whatever
is this do-able?
2007-07-27
16:39:10
·
6 answers
·
asked by
imapirateaarr
5