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

Dell XPS 13 9370 (2018) review

No need to scan sketches into your computer with Moleskine's new smart pen

WWDC history: Apple's product launches since 2005

Comment importer des contacts d’un iPhone à un autre iPhone ?