Mergeing cells in Excel

Time trying to merge cells in excel. I currently have a column with tag numbers 1,2,3 etc and a column for year of birth, 2019 in this example. I need a column that merges these and finish up as 1/19, 2/19, 3/19 etc etc
Any one have any hints how? i've tried Google but nae luck.
 

mezz

Member
Location
Ireland
The ampersand should do it.
Assuming data in cells A1 and A2
=A1&"/”&A2 formula should work. You may then want to copy it and paste special values only
 

Northern territory

Member
Livestock Farmer
Time trying to merge cells in excel. I currently have a column with tag numbers 1,2,3 etc and a column for year of birth, 2019 in this example. I need a column that merges these and finish up as 1/19, 2/19, 3/19 etc etc
Any one have any hints how? i've tried Google but nae luck.
Not entirely sure of your meaning but right click and alignment, merge cells is the way I do it after highlighting the cells you want merging together.
 

Will you help clear snow?

  • yes

    Votes: 68 32.2%
  • no

    Votes: 143 67.8%

The London Palladium event “BPR Seminar”

  • 8,064
  • 118
This is our next step following the London rally 🚜

BPR is not just a farming issue, it affects ALL business, it removes incentive to invest for growth

Join us @LondonPalladium on the 16th for beginning of UK business fight back👍

Back
Top