Thread
: [Solved]
How to merge two cells from sheet1 to one cell in sheet2 in next sheet
View Single Post
10-30-2011, 08:30 AM
Catalin.B
Windows Vista
Office 2010 32bit
Expert
Join Date: May 2011
Location: Iaşi, Romānia
Posts: 386
you setup excel option to reference R1C1 style, thats why the formula will look different: (excel options-formula-R1C1 reference style)
=Sheet1!RC[-1]&"-"&Sheet1!RC
Catalin.B
View Public Profile
Find all posts by Catalin.B