| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Merge cells with information
Hi-Someone please help, I am using a macro to format text to column
however because of the text has (/) the text is split into thre columns. Is there any way I can format this so that I can link all th 4 columns into one and for the text to make sense? the text is in column J(the begginng of the sentence) next Column K, M have the remaining pieces depending on the length of the sentence -- Message posted from http://www.ExcelForum.com |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Merge cells with information
Hi walan
Try this =J1&" " &K1 &" "&L1& " " &M1 -- Regards Ron de Bruin http://www.rondebruin.nl "walan " wrote in message ... Hi-Someone please help, I am using a macro to format text to columns however because of the text has (/) the text is split into three columns. Is there any way I can format this so that I can link all the 4 columns into one and for the text to make sense? the text is in column J(the begginng of the sentence) next Column K, L M have the remaining pieces depending on the length of the sentence. --- Message posted from http://www.ExcelForum.com/ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can i merge all the information into one ? | Excel Discussion (Misc queries) | |||
| How do I merge cells with different information? | Excel Discussion (Misc queries) | |||
| Merge information from different sheets in to 1 | Excel Discussion (Misc queries) | |||
| With Excel and Word is it possible to merge information together? | Excel Discussion (Misc queries) | |||
| Help :Merge 2 employee information tables | Excel Discussion (Misc queries) | |||
Linear Mode
