Jump to content


 


Register a free account to unlock additional features at BleepingComputer.com
Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.


Click here to Register a free account now! or read our Welcome Guide to learn how to use this site.

Photo

Excel References


  • Please log in to reply
4 replies to this topic

#1 stevenc1010

stevenc1010

  • Members
  • 34 posts
  • OFFLINE
  •  
  • Local time:02:44 AM

Posted 31 December 2008 - 04:51 PM

I am trying to create a field that is comprised of other fields. For example:

I want my A1 column text to be information from column B1, C1, and D1. So a formula would look like =A1-B1-D1 but obviously this will subtract tbe three cells from each other. I want it to look like Dog-Cat-Fish.

I hope I am explaining this well enough. I appreciate any help offered. Im not even sure if this is possible in excel though.

-Steve

BC AdBot (Login to Remove)

 


#2 jgweed

jgweed

  • Members
  • 28,473 posts
  • OFFLINE
  •  
  • Gender:Male
  • Location:Chicago, Il.
  • Local time:01:44 AM

Posted 31 December 2008 - 06:35 PM

Text does not work in the same way as numeric data, which seems to be what you want to accomplish; do I understand that you want words to subtract from themselves, or do you simply want to place (in your example) three words each from a different column, separated by a dash, in another column?
Cheers,
John
Whereof one cannot speak, thereof one should be silent.

#3 stevenc1010

stevenc1010
  • Topic Starter

  • Members
  • 34 posts
  • OFFLINE
  •  
  • Local time:02:44 AM

Posted 31 December 2008 - 06:50 PM

Like my example, I want column A1 to have three words separated by dashes from three other columns. However, A2 could be different because B2 is different from B1.

Sorry, a little tough to explain in writing. Thanks for the quick reply.

#4 tos226

tos226

    BleepIN--BleepOUT


  • Members
  • 1,574 posts
  • OFFLINE
  •  
  • Gender:Female
  • Location:LocalHost
  • Local time:02:44 AM

Posted 01 January 2009 - 09:40 PM

You do not want arithmetic operations, right?
You want words to be concatenated, but with dashes in between the words, and furthermore, you don't care if the length of those strings is unequal. If this is what you mean, just type this:
=B1 & "-" & C1 & "-" & D1

Regarding your "So a formula would look like =A1-B1-D1 but obviously this will subtract tbe three cells from each other"
Sorry, that's impossible! It will subtract B1 and D1 from A1 so long as those cells are numbers and not text :thumbsup:

Edited by tos226, 01 January 2009 - 09:47 PM.


#5 stevenc1010

stevenc1010
  • Topic Starter

  • Members
  • 34 posts
  • OFFLINE
  •  
  • Local time:02:44 AM

Posted 01 January 2009 - 11:41 PM

That is exactly what I needed. Thanks man, you just saved me a lot of time.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users