|

»

openoffice - users

Calc merge two columns

View: New views

3 Messages — Rating Filter: Alert me

	Calc merge two columns by Zhengquan Zhang-2 :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message Hello, openoffice community, I have two columns of text, they look like string1 \| string2 \| --------------------- \| string1 \| string2 \| --------------------- \| string1 \| string2 \| --------------------- how can I merge them to one column string1 string2 \| ---------------------\| string1 string2 \| ---------------------\| string1 string2 \| --------------------- Any help will be appreciated! -- Zhengquan --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscribe@... For additional commands, e-mail: users-help@...
	Re: Calc merge two columns by Zhengquan Zhang-2 :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message google helped me find this http://www.oooforum.org/forum/viewtopic.phtml?t=41040 THanks OO! 2009/11/3 Zhengquan Zhang <zhang.zhengquan@...>: > Hello, openoffice community, > > I have two columns of text, they look like > string1 \| string2 \| > --------------------- \| > string1 \| string2 \| > --------------------- \| > string1 \| string2 \| > --------------------- > > how can I merge them to one column > > string1 string2 \| > ---------------------\| > string1 string2 \| > ---------------------\| > string1 string2 \| > --------------------- > > > Any help will be appreciated! > > -- > Zhengquan > -- Zhengquan --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscribe@... For additional commands, e-mail: users-help@...
	Re: Calc merge two columns by Franz Wein :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message Hi use this form in column 3 = Col1 & " " & Col2 if you need a blank between the two strings or = Col1 & Col2 if you to concatenate the two Columns without a blank best regards Franz Wein Zhengquan Zhang schrieb: > Hello, openoffice community, > > I have two columns of text, they look like > string1 \| string2 \| > --------------------- \| > string1 \| string2 \| > --------------------- \| > string1 \| string2 \| > --------------------- > > how can I merge them to one column > > string1 string2 \| > ---------------------\| > string1 string2 \| > ---------------------\| > string1 string2 \| > --------------------- > > > Any help will be appreciated! > > --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscribe@... For additional commands, e-mail: users-help@...