Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft.excel.courses.in.london - Text functions
Resolved · Low Priority · Version Standard
Donna-marie has attended:
Excel Intermediate course
Excel Advanced course
How to combined two colomns of text together in one cell?
Hi Donna-Marie, Thank you for your question, to undertake this action you will need to use the Concatentate function. Assuming that you wished to combine data from cell B4 and C4 you can use the following function in a new cell (ie A4) =CONCATENATE(B4," ",C4), note the " " space between the two cell references, this is necessary to separate the two text items.
|
Excel tip:Editing Formulas in Excel CellsAlthough people like to edit a formula in the Formula bar, you can also edit a formula in the cell. |
We'll call during UK business hours
Server loaded in 0.08 secs.