Excel Spreadsheet Help Please

  harrycat 07:47 28 Mar 09

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?


  VoG II 08:07 28 Mar 09

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 09

Hi thanks,

numbers currently look like this


what I want is


Does that help?

Many Thanks

  harrycat 09:08 28 Mar 09

sorry the four spaces dissapeared when I posted.

Basically its fourspaces then 1234HG


  VoG II 10:06 28 Mar 09

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 09

Many Thanks.

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

AMD Ryzen release date, specifications and features: Three CPUs from the Ryzen 7 range now…

1995-2015: How technology has changed the world in 20 years

Glassworks Barcelona shows how it captured the artistic imagination of Conor in A Monster Calls

Best iPhone games 2017 | Best iPad games 2017: 162 fantastic iOS games that you need to play right…