Home > MOSS, MS SharePoint Sever > Creating a Calculated Column for Text instead of Numbers

Creating a Calculated Column for Text instead of Numbers

Lets say you have a Full Name column and Last Name column in your contact list. Now you want to create a new column that contains the Full Name of the contact.

What you can do is go back into your Contacts list and created a new calculated column called “FullName_calc“ with the purpose of joining your “First Name” (text) and “Last Name” (text) fields.  Now, here’s where the Coders and Application users can take separate paths,

You can do it using Excel formulas but if you come from a coding background you can also use VB to accomplish this task.  Here’s the two examples:

Using Excel:
=CONCATENATE([Last Name],”, “,[First Name])

Utilizing VB:
=[Last Name] & “, ” & [First Name]

Resulting Output for Both is a New Calculated Column:
Gul, Rehman

Advertisements
  1. April 26, 2007 at 5:15 pm

    Well thats a handy tip!

  2. April 26, 2007 at 5:20 pm

    thanks dude!

  1. January 6, 2010 at 9:24 am

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: