Separate a column into 2

teebruin · Mar 29th, 2002, 11:07 AM

I have an item number and description in a column all together. The item numbers are all 5 digits followed by the description. Is there a way to remove the first 5 characters and put them into a new column?

Thanks in advance for any help.

lenze · Mar 29th, 2002, 11:19 AM

Data, Text to Columns

Ed Namzug · Mar 29th, 2002, 11:26 AM

Hi teebruin,
Just to elaborate on what lenze have said,
highlight the desired column,go to Data, text to columns, fixed width, next, create your breakline on desired position then finish...
Happy Easter...!
Ed Namzug

teebruin · Mar 29th, 2002, 11:37 AM

Thank You. I knew it would be something simple.

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

Mar 29th, 2002, 11:07 AM	#1
teebruin New Member Join Date: Mar 2002 Posts: 38	I have an item number and description in a column all together. The item numbers are all 5 digits followed by the description. Is there a way to remove the first 5 characters and put them into a new column? Thanks in advance for any help.

Mar 29th, 2002, 11:19 AM	#2
lenze MrExcel MVP Join Date: Feb 2002 Location: Helena, MT Posts: 13,690	Data, Text to Columns

Mar 29th, 2002, 11:26 AM	#3
Ed Namzug New Member Join Date: Mar 2002 Location: Los Angeles, CA Posts: 9	Hi teebruin, Just to elaborate on what lenze have said, highlight the desired column,go to Data, text to columns, fixed width, next, create your breakline on desired position then finish... Happy Easter...! Ed Namzug

Mar 29th, 2002, 11:37 AM	#4
teebruin New Member Join Date: Mar 2002 Posts: 38	Thank You. I knew it would be something simple.