View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
idaho_mountainman idaho_mountainman is offline
external usenet poster
 
Posts: 2
Default multiple cells in a spreadsheet

Thank You, that worked great.

"Dave Peterson" wrote:

I would insert a new column (adjacent to the original) and a formula like:

="Part Number: " & a1
And drag down as far as I needed.

idaho_mountainman wrote:

If I have 279 cells with a part number in each cell and I want to add "Part
Number:" inside each cell how do I do it?
Cell would originally be - AA55487-4

I want it to be - Part Number: AA55487-4
when I am done. Each cell has a unigue part number.


--

Dave Peterson