Excel 2002: How to add blank spaces to text and numbers

M

Mr. Low

Dear Sir,

May I know how to add 3 empty spaces in front and behind text and numbers ?

What formula must I use at cell B1 and C1?

A B c
1 PTY _ _ _PTY PTY_ _ _
2 5412 _ _ _5412 5412 _ _ _
3 JH65
4

Thanks


Low
 
F

FSt1

hi
if you mean "empty spaces" then
=" "&A1 and =A1&" "
but if you mean "Under score" then
="___" & A1 and =A1 &"___"

advise me if i misunderstood.

Regards
FSt1
 
M

Mr. Low

Hello,

Thanks for your formula.

I mean "empty spaces"

Anyway your formula is helpful for me if I choose the otherway.

Thanks

Low
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a sequence number(question number) to a paragraph which has a question and 4 options and answer 0
Adding sequence numbers to paragraphs 0
How can the font and size of (all) citation numbers be altered? 1
Finding the proper style field and the numbered paragraph value within the style 0
Finding the right style field in VBA 0
Excel 2002: How to eliminate empty spaces ? 1
Excel 2002: How to convert number to text ? 7
Excel 2002 : How to remove trailing spaces ? 4

Top