footballcmr2

Posts: n/a

How do I strip out some parts of a column of text data?

I have a column of text data, which happens to be 11 characters wide. I want
to strip the right-most 6 characters out of the entire column, without having
to do each cell one at a time. For example I want to to from this data: 2039
041175 to this data: 2039 for all 350 or so rows of data in the column on the
Excel sheet.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Count Position of Filtered TEXT cells in a column	Sam via OfficeKB.com	Excel Worksheet Functions	8	May 18th 05 04:23 AM
Count Position of Filtered TEXT cells in a column	Sam via OfficeKB.com	Excel Worksheet Functions	0	May 15th 05 08:14 PM
Return Count for LAST NonBlank Cell in each Row	Sam via OfficeKB.com	Excel Worksheet Functions	12	April 17th 05 10:36 PM
up to 7 functions?	ALex	Excel Worksheet Functions	10	April 12th 05 06:42 PM
Counting NUMBERS &/or TEXT from a column to other sheet ?	Trixie	Excel Worksheet Functions	4	March 3rd 05 07:59 PM

All times are GMT +1. The time now is 03:36 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us