| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Concatenate
I'm doing a concatenate of two cells together, but when it combines the data it combines it. i want to seperate the data with a dash and a space, how can i do this without going through the 12,000 lines in the excel file? Here is an example: This is what it looks like now CS100FPFont By-Pass kit W/ 4-Bolt flange Chevy Duramax 2001-2005 I want it to look like this CS100FP - Font By-Pass kit W/ 4-Bolt flange Chevy Duramax 2001-2005 -- RChicken ------------------------------------------------------------------------ RChicken's Profile: http://www.excelforum.com/member.php...o&userid=33601 View this thread: http://www.excelforum.com/showthread...hreadid=560176 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Concatenate
Hi, If your text is in A1 and B1. Enter the following in the cell that you are concatenating: =A1 & " - " & B1 HTH, SamuelT -- SamuelT ------------------------------------------------------------------------ SamuelT's Profile: http://www.excelforum.com/member.php...o&userid=27501 View this thread: http://www.excelforum.com/showthread...hreadid=560176 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Concatenate
thank you, that worked great. -- RChicken ------------------------------------------------------------------------ RChicken's Profile: http://www.excelforum.com/member.php...o&userid=33601 View this thread: http://www.excelforum.com/showthread...hreadid=560176 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Concatenate | Excel Discussion (Misc queries) | |||
| IF, IF, Concatenate? | Excel Worksheet Functions | |||
| Using Concatenate inside a vlookup | Excel Worksheet Functions | |||
| Match and Concatenate ?? | Excel Worksheet Functions | |||
| Concatenate cells without specifying/writing cell address individually | Excel Discussion (Misc queries) | |||
Linear Mode
