Insert Semicolon and delete space in a list

**nguyeda** · 06-03-2011, 08:27 AM

Hello,

How can I get word to insert a semicolon after a list of numbers and delete the space in between to make a long continous list?

ie Copy this list from excel:

123456
123456
748979
498784

then make Word have it say

123456; 123456; 748979; 498784;

I'd do that myself but I can't tolerate it 2,200 times.

Thanks!

**nguyeda** · 06-03-2011, 08:34 AM

Ok, I inserted the semi colon in excel. Now I just have a list, how do I delete the space so the numbers are next to each other?

**Marcol** · 06-03-2011, 08:48 AM

Try this in Excel

Assumuing your data is in A2 Down
In B2

=IF(B1="",A2&"; ",B1&A2&"; ")

Drag/Fill Down (Double click the Fill handle)

Copy & Paste the last line into word at your desired location.

[EDIT]
To find the last line Select B2 then press Ctrl+Arrow Down

[EDIT 2]
You ask to delete the space between, but show a space in your expected result.
If you don't want the space use ";" in the formula rather than "; ".

**zbor** · 06-03-2011, 09:05 AM

maybe this: http://www.excelforum.com/2164601-post2.html

**nguyeda** · 06-03-2011, 09:10 AM

Thanks guys, wish I saw this before I did what I did but it worked!

I just added special formatting to include the semi colon, pasted in to word as text, pasted that in to notpad between <html></html> tags and opened it in the browser. So HTML took out the spaces!

Hahah sort of smart workaround?