Extracting numbers from a string

Zac · Mar 20th, 2002, 05:52 AM

Take 123456789
I want to extract each number into 9 consecutive cells.
1 will be in A1,
2 will end up in B1,
etc.

How can I accomplish this. I've tried different
things using the RIGHT function, but I'm stuck.

Need your help,
Thanks,
Zac

Aladin Akyurek · Mar 20th, 2002, 06:00 AM

Zac,

Lets say that the target number is in A1.

In B1 enter:

=MID($A$1,COLUMN()-1,1)

and copy across as far as needed.

Or use Data|Text to Columns, where you choose 'Fixed Width' and bring break lines between each digit by clicking at desired locations.

Aladin

Zac · Mar 20th, 2002, 06:06 AM

I'll try it later on, thanks.
Have a meeting from 8:00 till 4:00 today.

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

Mar 20th, 2002, 05:52 AM	#1
Zac Board Regular Join Date: Feb 2002 Location: Mike Posts: 796	Take 123456789 I want to extract each number into 9 consecutive cells. 1 will be in A1, 2 will end up in B1, etc. How can I accomplish this. I've tried different things using the RIGHT function, but I'm stuck. Need your help, Thanks, Zac

Mar 20th, 2002, 06:00 AM	#2
Aladin Akyurek MrExcel MVP Join Date: Feb 2002 Location: The Hague Posts: 50,317	Zac, Lets say that the target number is in A1. In B1 enter: =MID($A$1,COLUMN()-1,1) and copy across as far as needed. Or use Data\|Text to Columns, where you choose 'Fixed Width' and bring break lines between each digit by clicking at desired locations. Aladin

Mar 20th, 2002, 06:06 AM	#3
Zac Board Regular Join Date: Feb 2002 Location: Mike Posts: 796	I'll try it later on, thanks. Have a meeting from 8:00 till 4:00 today.