How to combine text of two cells

  • Thread starter Thread starter David Lewis
  • Start date Start date
D

David Lewis

I have two cells containing numbers like
10 & 13
I need to combine them in one cell so they display
10/13
 
Assuming that both number cells are formatted "general"
here's how you do it using this format.

=A1&"/"&B1

Assumes:
Cell A1 = 10
Cell B1 = 13

The numbers are assumed to be text and can be combined by
using the "&" key. Any additional text that you want to
add can be done by enclosing in quatation marks.
 
If I may jump in, hood's formula actually works with either text or numbers.
The result will always be text.

If by chance you're attempting to make a date, this won't do it. Dates are
not text. Post back.
 
yes its for dates
On the top of the time sheet is 3 boxes for month / day / year
then there is 7 columns for each day of the week. I want to enter only one date
and let the spread sheet figure out the rest

"Earl Kiosterud" <[email protected]>
|>If I may jump in, hood's formula actually works with either text or numbers.
|>The result will always be text.
|>
|>If by chance you're attempting to make a date, this won't do it. Dates are
|>not text. Post back.
 
To combine numeric values to dates use the date function

=DATE(year_cell,month_cell,day_cell)
 
Yes I am using it for dates.
Works perfect, thankx!!

"Earl Kiosterud" <[email protected]>
|>If I may jump in, hood's formula actually works with either text or numbers.
|>The result will always be text.
|>
|>If by chance you're attempting to make a date, this won't do it. Dates are
|>not text. Post back.
 
Back
Top