"Fix the reference" means add $ signs to the cell reference to keep it Absolute
as opposed to Relative. See Help on this subject.
Assuming G1 contains the "
Column A contains the text entries.
In B1 enter =A1 & $G$1 then double-click on the fill handle of B1 to copy down
to end of data in Column A.
The A1 will increment but $G$1 will not.
When happy, select column B and copy.
Paste Special(in place)ValuesOKEsc
Clear the contents of G1 and delete Column A
Gord Dibben MS Excel MVP
On 19 Jun 2006 07:22:00 -0700, "doiley6167" wrote:
Thx for the promt response. I am quite a noobie when it comes to
excel. What do you mean by fix the reference in 3)
Thx
oteixeira wrote:
Hello.
1.Just write the double quotation in a empty cell.
2.In a column in front of your data enter a formula:
+<The first cell of your data range&<Cell where you wrote the double
quotation
3.Fix ($) the reference to the cell containing the double quotation.
4.Copy this cell until the end of your data.
5.Don't forget to transform you new data in Values.
Hope this helps
--
oteixeira
------------------------------------------------------------------------
oteixeira's Profile: http://www.excelforum.com/member.php...o&userid=35320
View this thread: http://www.excelforum.com/showthread...hreadid=553224