How to add prefixes into data of table in Word? Not copy/paste the prefix.

Question

0.00/5 (No votes)

See more:

I use MSWord to create a data table, I need add prefixes into data in it (on every column), e.g:
Column 1:
32
45
65
345
7656
545
...

I want to add prefixe "-4.3" in front of data on this column to receive it the following:
Column 1 (after add prefix):
-4.332
-4.345
-4.365
-4.3345
-4.37656
-4.3545
...
How to do this. Thanks.

Posted 15-Feb-11 22:18pm

Andrewpeter

Updated 15-Feb-11 22:20pm

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Abdul Quader Mamun · Answer 1 · 2011-02-15T23:05:00

Solution 1

Thank you for your question, in MS Word 2007.

Use:

Insert>>Table>> Excel Spreadsheet>>
(use like excel function).
=CONCATENATE("-4.3",B1)Result is -4.332 where b1 equals to 32
=CONCATENATE("-4.3",B2)Result is -4.345 where b2 equals to 45
=CONCATENATE("-4.3",B3)Result is -4.365 where b3 equals to 65
=CONCATENATE("-4.3",B4)Result is -4.3345 where b4 equals to 345

Thanks,
Mamun

Posted 15-Feb-11 23:05pm

Abdul Quader Mamun

Comments

Andrewpeter 16-Feb-11 5:57am

Thank you for your reply, I use MSWord 2003 so not have that function, I'll copy it to Excel to do this as your support, my vote to your answer is 5. Hope others help me more!