How to remove spaces that before the number

jeh · May 25th, 2002, 01:38 AM

I have a column of numbers that were brought in from a data base. Some of the numbers have two, or three spaces before the number.

How can I get rid of the spaces before the numbers?

Thanks for your time,

Jim

Aladin Akyurek · May 25th, 2002, 01:43 AM

I have a column of numbers that were brought in from a data base. Some of the numbers have two, or three spaces before the number.

How can I get rid of the spaces before the numbers?

Jim,

Activate an unused cell, Edit|Copy it, select all the target cells, execute Edit|Paste Special >Add.

Aladin

[ This Message was edited by: aladin akyurek on 2002-05-25 01:04 ]

jeh · May 25th, 2002, 01:50 AM

Hi Aladin, Thanks for the reply.

I don't quite understand what you mean.

Jim

Tom Schreiner · May 25th, 2002, 02:01 AM

Your numbers are being entered as text.
If, for instance, your numbers are in Cells A1 to A10, select this range, right click, choose copy, right click again, choose paste special, choose Add, then Ok. This will change your numbers from text to numeric ridding you of your leading and or trailing spaces.

Tom

[ This Message was edited by: TsTom on 2002-05-25 01:01 ]

jeh · May 25th, 2002, 02:15 AM

Hi Tom & Aladin,

Thank you very much. works perfect.

Sorry about the misunderstanding, I have alot left to learn about Excel.

Thanks to both of you,

Jim

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 25th, 2002, 01:38 AM	#1
jeh Board Regular Join Date: Apr 2002 Location: Washington State, USA Posts: 250	I have a column of numbers that were brought in from a data base. Some of the numbers have two, or three spaces before the number. How can I get rid of the spaces before the numbers? Thanks for your time, Jim

May 25th, 2002, 01:43 AM	#2
Aladin Akyurek MrExcel MVP Join Date: Feb 2002 Location: The Hague Posts: 50,317	I have a column of numbers that were brought in from a data base. Some of the numbers have two, or three spaces before the number. How can I get rid of the spaces before the numbers? Jim, Activate an unused cell, Edit\|Copy it, select all the target cells, execute Edit\|Paste Special >Add. Aladin [ This Message was edited by: aladin akyurek on 2002-05-25 01:04 ]

May 25th, 2002, 01:50 AM	#3
jeh Board Regular Join Date: Apr 2002 Location: Washington State, USA Posts: 250	Hi Aladin, Thanks for the reply. I don't quite understand what you mean. Jim

May 25th, 2002, 02:01 AM	#4
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Your numbers are being entered as text. If, for instance, your numbers are in Cells A1 to A10, select this range, right click, choose copy, right click again, choose paste special, choose Add, then Ok. This will change your numbers from text to numeric ridding you of your leading and or trailing spaces. Tom [ This Message was edited by: TsTom on 2002-05-25 01:01 ]

May 25th, 2002, 02:15 AM	#5
jeh Board Regular Join Date: Apr 2002 Location: Washington State, USA Posts: 250	Hi Tom & Aladin, Thank you very much. works perfect. Sorry about the misunderstanding, I have alot left to learn about Excel. Thanks to both of you, Jim