application development excel - creating formulas

AI Training: For Busy Decision Makers & Professionals Book now

Forum home » Delegate support and help forum » Microsoft Excel Training and help » application development excel - Adding strings to formulas

application development excel - Adding strings to formulas

resolvedResolved · Low Priority · Version Standard

Dafni has attended:
Excel Advanced course
Access Advanced course
Word Advanced course

Adding strings to formulas

how to add strings

RE: creating formulas

Dafni,

I am note 100% sure about your question, so I will assume you want to add strings together from 2 cells into one.

You can use the CONCATENATE function for text strings.

=CONCATENATE(E2,"-",F2)

Try it out for yourself, and see if it is what you are looking for.

Richard


 

Excel tip:

Change the default location for opening and saving spreadsheets

If you are always opening spreadsheets from and/or saving documents to a specific location that is not My Documents, save time by setting this folder as the default for opening files from and saving files to.

Here's how:
1. Go to Tools - Options.

2. Select the General tab.

3. Enter the pathname of the folder you wish to make the default in the Default File Location box (hint: it will be easier to use Windows Explorer to navigate to this folder, then copy and paste the pathname from the address bar at the top of the Windows Explorer screen).

4. Click OK.

You have now changed the default folder for opening and saving spreadsheets.

View all Excel hints and tips


Server loaded in 0.12 secs.