Hi! Trying to split a column but column break is greyed out. I have a street address and need to break the street # in one column column and the street name in another. i.e. 22 First Street ... I need the 22 in one column and the rest in another column. Is this possible?
MacBook Pro 15″, macOS 13.6
Hi ifstockwell,
TEXTBEFORE and TEXTAFTER. Find the first space.
Formula in C2 is TEXTBEFORE(B2," ")
Formula in D2 is TEXTAFTER(B2," ")
Regards,
Ian.
Hi ifstockwell,
TEXTBEFORE and TEXTAFTER. Find the first space.
Formula in C2 is TEXTBEFORE(B2," ")
Formula in D2 is TEXTAFTER(B2," ")
Regards,
Ian.
I'm glad that Ian was able to give you a solution you were looking for. Just to explain why "Column Break" was grayed out, it's a text function that is only active in a Text container that supports multiple column text format. That would most commonly be a Text Box in Numbers.
Jerry
I have a table with several narrow columns, and the last column being quite large/wide. Every time I try to print, it I cannot somehow get just the last/wide column to print on a separate page. I tried to use column break, but it is greyed out. Anything that would help me on this?
Thanks,
Janet
Thanks Yellowbox that's awesome! Much appreciated.
Hi Janet,
Which version of Numbers are you using, Numbers for Mac, or Numbers for iOS? And, what device are you running it on?
Knowing will help us give more specific advice.
Thanks,
Jerry
Column Break
