Excel Spreadsheet Help Please

  harrycat 07:47 28 Mar 2009
Locked

Hi, I have a column of about 2000 numbers, I want to put four spaces at the fron of the numbers. Is there an easy way to do this on a Excel spreadsheet?

Thanks

  VoG II 08:07 28 Mar 2009

That's a bit unclear to me. Do you mean that you want to:

a) pad them with four spaces in front? They won't be treated as numbers anymore if you do that.

b) make them *appear* to have 4 spaces in front but still be treated as numbers.

c) be padded with leading zeroes.

A few examples would help.

  harrycat 09:06 28 Mar 2009

Hi thanks,

numbers currently look like this

1234HG

what I want is

1234HG


Does that help?

Many Thanks

  harrycat 09:08 28 Mar 2009

sorry the four spaces dissapeared when I posted.

Basically its fourspaces then 1234HG

Thanks

  VoG II 10:06 28 Mar 2009

Say they are in column A starting at A1.

In B1 enter

=" "&A1

where there ate 4 spaces between the " marks.

Then hover the cursor over the bottom right of B1 - the cursor should turn into a + then double-click to copy the formula down.

Copy the cells in column B, click in A1, Edit > Paste Special, tick Values and click OK.

Delete column B.

  harrycat 21:06 28 Mar 2009

Many Thanks.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

OnePlus 5 review

50 best online Adobe XD tutorials

iPad Pro 10.5in (2017) review

Comment connecter un MacBook à une TV ?