User Tools

Site Tools


spreadsheets

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
spreadsheets [2019/03/21 09:33]
ais
spreadsheets [2019/03/21 09:35] (current)
ais
Line 73: Line 73:
 {{  :​multi_owner_name2.png?​direct&​700 ​ |}}\\ {{  :​multi_owner_name2.png?​direct&​700 ​ |}}\\
  
-  * Now you need to concatenate (combine) the two Owner Names into one column in cell D. Click into cell D2 and then into the Formula Bar. You need to concatenate cells E2 and F2. Now type <code tsql> =CONCATENATE(TRIM(E2),"​ ",​TRIM(F2)) </​code>​ into the Formula Bar (as seen in the image below) and then hit the Enter key. To apply the formula to all rows in column D, click into D2 and locate the box in the lower right corner as circled in the image below. The cursor should turn into a plus sign (+) and then double-click. ​ \\+  * Now you need to concatenate (combine) the two Owner Names into one column in cell D. Click into cell D2 and then into the Formula Bar. You need to concatenate cells E2 and F2. Now type <code tsql>​=CONCATENATE(TRIM(E2),"​ ",​TRIM(F2)) </​code>​ into the Formula Bar (as seen in the image below) and then hit the Enter key. To apply the formula to all rows in column D, click into D2 and locate the box in the lower right corner as circled in the image below. The cursor should turn into a plus sign (+) and then double-click. ​ \\
  
 {{  :​multi_owner_name_3.png?​nolink&​700 ​ |}} {{  :​multi_owner_name_3.png?​nolink&​700 ​ |}}
spreadsheets.txt ยท Last modified: 2019/03/21 09:35 by ais