Excel, Add character to end of each cell

zeus · 07-10-2006, 01:01 AM

I need to put a comma after the text in all my cells, ie A1, A2, A3 etc

Does anyone know how I can do this? I tries saving it as .csv and opening it in notepad but the commas weren't there. Its a bit odd because tab delimited files have the tab space in notepad.

Also does anyone know how I can change my rows into columns?
ie instead of A1, A2, A3 etc I might well need it to be A1, B1, C1.

Ive got a list of images in column A and need to do a search for them on my hdd. Last time I had a text wrapped word file with all the file names from excel and a comma after each one. It was almost a year (to the day!!) since I did this last and I simply cant remember how to use excel!

donkey42 · 07-10-2006, 09:18 AM

Quote:

Originally Posted by zeus

I need to put a comma after the text in all my cells, ie A1, A2, A3 etc

dunno, sorry

Quote:

Originally Posted by zeus

Does anyone know how I can do this? I tries saving it as .csv and opening it in notepad but the commas weren't there. Its a bit odd because tab delimited files have the tab space in notepad.

i think you can "Save As" commer delimited - or something

Quote:

Originally Posted by zeus

Also does anyone know how I can change my rows into columns?

yeah, right click seleted cells, and choose "Copy" then select the other cells, right click, and choose "Paste Special" and put a tick in the box (Transpose) - something like that

Quote:

Originally Posted by zeus

Ive got a list of images in column A and need to do a search for them on my hdd. Last time I had a text wrapped word file with all the file names from excel and a comma after each one. It was almost a year (to the day!!) since I did this last and I simply cant remember how to use excel!

dunno, sorry - i'm no expert in excel

zeus · 07-10-2006, 11:51 AM

Thanks Donkey. "Transpose" was the word I needed to help me finish it off! I use matrices in maths all the time which involve transposing but the word just didnt pop up in my head when searching with google.

After very nearly throwing the screen out the window; ive done it!

Open list in excel, save as webpage, open webpage and copy text. Open Quattro Pro, special paste text, select cells, tools, numeric, transpose. Save as ascii comma delimited and Ive got my list. ready to open in notepad.
http://www.hardwareforums.com/galler...0-untitled.JPG

I just hope I dont forget typing that in here for next time!

I didnt need to put a comma on the end of each cell after all. But its possible using =A1&"," in cell B1 then by copying the formula down list.

donkey42 · 07-10-2006, 01:20 PM

no, the ampersand (&) is used to make a cell / cell absolute, that means the row number can change but not the column or vice virsa (e.g.

&A1 = column abolute
A&1 = row absoute

A1& - i dont think this would make any sense to excel, but i could be wrong, this crap has being dragged kicking & screaming from my stupid memory, it been about 10 years since i did anything with excel, and that was excel 95, so i wouldn't be supprised if they didn't work

zeus · 07-10-2006, 01:39 PM

It definatly worked. I ended up with two commas because of how Quattro Pro saves .csv so had to go back a few steps.

Here is the thread from excel forums...
add comma to end of each cell - Excel Help Forum

donkey42 · 07-10-2006, 01:54 PM

oh! right, well if it work then go with it

Off Topic:

i've being thinking about it and i thought you put a "+" before an item you wanted to put in a cell script, oh well never mind

zeus · 09-06-2007, 04:13 PM

Quote:

Originally Posted by zeus

I just hope I dont forget typing that in here for next time!

well I didnt forget

Im just bumping this to the top so I dont have to keep searching for it! Selfish I know

Im so glad I wrote these steps down for myself, I always forget how to do this.

Rik, dont forget this....
WPU Forums - Quattro Pro annoyance

07-10-2006, 01:01 AM	#1 (permalink) Top
zeus out of date Join Date: May 2003 Age: 27 Male Posts: 1,654 Times Helpful: 105 My Mood: Twisted Status: Offline My Computer	Excel, Add character to end of each cell I need to put a comma after the text in all my cells, ie A1, A2, A3 etc Does anyone know how I can do this? I tries saving it as .csv and opening it in notepad but the commas weren't there. Its a bit odd because tab delimited files have the tab space in notepad. Also does anyone know how I can change my rows into columns? ie instead of A1, A2, A3 etc I might well need it to be A1, B1, C1. Ive got a list of images in column A and need to do a search for them on my hdd. Last time I had a text wrapped word file with all the file names from excel and a comma after each one. It was almost a year (to the day!!) since I did this last and I simply cant remember how to use excel!

07-10-2006, 11:51 AM	#3 (permalink) Top
zeus out of date Join Date: May 2003 Age: 27 Male Posts: 1,654 Times Helpful: 105 My Mood: Twisted Status: Offline My Computer	Thanks Donkey. "Transpose" was the word I needed to help me finish it off! I use matrices in maths all the time which involve transposing but the word just didnt pop up in my head when searching with google. After very nearly throwing the screen out the window; ive done it! Open list in excel, save as webpage, open webpage and copy text. Open Quattro Pro, special paste text, select cells, tools, numeric, transpose. Save as ascii comma delimited and Ive got my list. ready to open in notepad. http://www.hardwareforums.com/galler...0-untitled.JPG I just hope I dont forget typing that in here for next time! I didnt need to put a comma on the end of each cell after all. But its possible using =A1&"," in cell B1 then by copying the formula down list. Last edited by zeus; 07-10-2006 at 11:57 AM.

07-10-2006, 01:20 PM	#4 (permalink) Top
donkey42 Paranoid Geeky Geek Join Date: Mar 2006 Age: 34 Male Posts: 5,826 Times Helpful: 309 My Mood: Paranoid Status: Offline My Computer	no, the ampersand (&) is used to make a cell / cell absolute, that means the row number can change but not the column or vice virsa (e.g. &A1 = column abolute A&1 = row absoute A1& - i dont think this would make any sense to excel, but i could be wrong, this crap has being dragged kicking & screaming from my stupid memory, it been about 10 years since i did anything with excel, and that was excel 95, so i wouldn't be supprised if they didn't work __________________ GRUB manual \| Google Linux \| Distrowatch \| Linux Chix \| Kubuntu \| My Mini City

07-10-2006, 01:54 PM	#6 (permalink) Top
donkey42 Paranoid Geeky Geek Join Date: Mar 2006 Age: 34 Male Posts: 5,826 Times Helpful: 309 My Mood: Paranoid Status: Offline My Computer	oh! right, well if it work then go with it Off Topic: i've being thinking about it and i thought you put a "+" before an item you wanted to put in a cell script, oh well never mind __________________ GRUB manual \| Google Linux \| Distrowatch \| Linux Chix \| Kubuntu \| My Mini City

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel Scrolling	duffgun	General Software	5	24-08-2006 11:58 PM
MS Excel 2003 Help - URGENT!!!	blade	General Software	3	20-08-2006 06:12 PM
Excel problem pc	cazmal	General Software	6	03-08-2006 10:43 PM
Excel Madness...	Waffle	General Software	1	12-01-2006 10:47 PM
Excel Issue	MagicalVacation	General Software	1	28-09-2003 04:56 PM

07-10-2006, 01:39 PM	#5 (permalink) Top
zeus out of date Join Date: May 2003 Age: 27 Male Posts: 1,654 Times Helpful: 105 My Mood: Twisted Status: Offline My Computer	It definatly worked. I ended up with two commas because of how Quattro Pro saves .csv so had to go back a few steps. Here is the thread from excel forums... add comma to end of each cell - Excel Help Forum

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)