| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Return while useing CONCATENATE
I have list of cell that I am combining. I need some help in placing a
RETURN so that the combined cells are on more then one like. example. From: Project Manager John Doe Section 23 =CONCATENATE(B3," ",B4," ",B5) To: Project Manager John Doe Section 23 -- Work is sometimes hard....but someone has to do it. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Return while useing CONCATENATE
=CONCATENATE(B3 & CHAR(10), B4 & CHAR(10),B5)
-- Gary''s Student - gsnu200845 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Return while useing CONCATENATE
Hours of searching done in 5 mins, thanks
-- Work is sometimes hard....but someone has to do it. "Gary''s Student" wrote: =CONCATENATE(B3 & CHAR(10), B4 & CHAR(10),B5) -- Gary''s Student - gsnu200845 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Return while useing CONCATENATE
Or this:
=CONCATENATE(B3,CHAR(10),B4,CHAR(10),B5) or =B3&CHAR(10)&B4&CHAR(10)&B5 Gary''s Student wrote: =CONCATENATE(B3 & CHAR(10), B4 & CHAR(10),B5) -- Gary''s Student - gsnu200845 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hard return in concatenate | Excel Worksheet Functions | |||
| Concatenate results of scores and return sum of percentages | Excel Worksheet Functions | |||
| Concatenate with carriage return- how to remove blanks? | Excel Worksheet Functions | |||
| how insert the return key in formulas for concatenate of text? | Excel Discussion (Misc queries) | |||
| Using concatenate to include a line return | Excel Discussion (Misc queries) | |||
Linear Mode
