• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer
WittySparks Logo White

WittySparks

Ignite Your Thoughts

  • Topics
  • Reviews
  • Newsletter
WittySparks / Technology / Software / Some smart tips on MS Excel 2007-Join & insert space between text

Some smart tips on MS Excel 2007-Join & insert space between text

Software December 27, 2009 by Kartik Subramaniam

When there are loads of data in MS Excel which have to be formatted, it might come across as a lot of work unless you know the right shortcuts and functions. This time we take you through some tips to join text and do some smart formatting like inserting space between them.

Office Excel 2007
Office Excel 2007

Let’s say you have the following set of text:

Microsoft Excel Sample Data
Microsoft Excel Sample Data

Now, you need to get the text in cells A1, B1, C1 in one cell. This would require a concatenate function and you would have to type.

Microsoft Excel Concatenate

And the desired result would be as appears below. To get the same result for all values in the range, just use the fill handle and drag and get all the cells with the same result.

Microsoft Excel

To get a space between the text that you have got after using the concatenate function, you would have to make the following adjustments to the same formula! And you would get the text with the desired space between the text.

Microsoft Excel

There is one more way to represent the same formula, which is to remove the commas and insert the ampersand(&) in its place along with space within the inverted commas.

Microsoft Excel

Hope this piece of information was useful to you. We would come up with more utility functions in the days to come, so watch the blog.

Related Topics

  • FlexClip Review: Is it the right tool for Video Creators?
  • Hubstaff Review: Is it the best time tracking tool?
  • Website Analytics: Almost Everything You Need To Know
Previous Post: « Email This with MailCounter – Tweetmeme for email?
Next Post: Pranav Mistry and his SixthSense »
Profile picture for Kartik Subramaniam

About Kartik Subramaniam

A dreamer of sorts & a Creative writer, passionate about reading diverse stuff.

View all posts by Kartik Subramaniam

Primary Sidebar

Search

Exclusive Coupons

  • Moqups coupon code: WITTYSPARKS for 20% or PARTNERS50 for 50% discount.
  • WPForms coupon code: WITTYSPARKS for 50% off.
  • Serpstat coupon code: wittysparks_discount for 30% off.
  • SEO Buddy coupon code: WITTYSPARKS for 25% off.
  • Morningscore coupon code: wittysparks for 30% off for 3 months.
  • FlexClip coupon code: WITTYSPARKS for 30% off.
  • Uplead coupon code: “witty” for 30-day free trial.
  • FastestVPN coupon codes: WITTYSPARKS15 or WITTYSPARKS10 or Get up to 93% OFF.
  • Outranking.io coupon code: WITTYSPARKS50 for 50% off.

For more such offers visit our exclusive offers for SEO, Bloggers, Marketers and for Business owners.

Featured Productivity Software

Notion logo
Notion

Whether you’re a solo entrepreneur or a large team, Notion Workspace can help you stay organized and get more done. Get started today and take your productivity to the next level.

Try Notion for FREE

Footer

Affiliate Disclosure

If you make a purchase from WittySparks links, we will receive a small commission. See our Affiliate Disclosure.

Sponsors

Partnered with FreePik to use the licensed images.

turn to dhgate for smartphone

Follow Us

  • Facebook
  • Twitter
  • Pinterest
  • LinkedIn
  • Instagram
  • YouTube
  • RSS

Copyright © 2023 · Hosting sponsored by Rocket.net (Affiliate link)

  • About Us
  • Contact Us
  • Privacy Policy
  • LinkedIn
  • Twitter
  • Like
  • Pinterest