MSFN Forum: [help] Adding additional info within cell - MSFN Forum

Jump to content



Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

[help] Adding additional info within cell Rate Topic: -----

#1 User is offline   D8TA 

  • Member
  • PipPip
  • Group: Members
  • Posts: 136
  • Joined: 18-February 05

Posted 19 June 2006 - 11:46 AM

I have an Excel spreadsheet that I need to add the letters PC to. Basically, this spreadsheet was exported from our asset management system so I have several rows with our PC numbers but they are listed as 10000C or 2456N. I need to add PC to the front of these asset numbers so they look like PC10000C and PC2456N. I remember doing this many years ago but don't remember how I did it. I thought I had used Access also to get my results but any help would be appreciated.

Thanks!


#2 User is offline   D8TA 

  • Member
  • PipPip
  • Group: Members
  • Posts: 136
  • Joined: 18-February 05

Posted 20 June 2006 - 06:03 AM

I found a way. I added a new column the went to Insert|Function then used Concatenate.

Works like a charm!

Share this topic:


Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users



All trademarks mentioned on this page are the property of their respective owners
Copyright © 2001 - 2011 msfn.org
Privacy Policy