Hi.
I'm looking for formula to break line into two cells ( A1 and A2). If words are too long to fit fixed column width.
example, "105/5, Vegeshwari Buildign, 105/5,vgshwrbuildign,mamulpetb-53, @Mamulpet, Bangalore" in B1
(by the way, I've added "@" as marker where to cut.)
if "@" is present, then "105/5, Vegeshwari Buildign, 105/5,vgshwrbuildign,mamulpetb-53," will be in A1 and "Mamulpet, Bangalore" in A2
if "@" is not added , then the whole line is in A1
Hope I've explained well enough.
Thanks in advance for the help.