LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Jim
 
Posts: n/a
Default Text to Columns from the Left

I have a column that has the following:

***************025
25

I need to reduce the column width, but I need to keep the
numbers and 9 stars. When I use text to columns, it wants
to seperate the records with stars from the records with
just numbers. Any idea's?

Thanks Guys !!
Jim
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
text from one column into multiple columns Jeff Brown Excel Discussion (Misc queries) 6 December 22nd 04 10:07 PM
Text to columns will not shut off. Gerald Cornforth Excel Worksheet Functions 5 December 15th 04 01:39 AM
Why text to columns is not available when there is mulipule line . Bing Excel Worksheet Functions 1 December 8th 04 05:14 AM
Splitting text in one column into two (or more) columns. RickyDee Excel Worksheet Functions 4 December 7th 04 10:03 PM
COUNTIF With Multiple Dates, Columns and Text Shannon Excel Worksheet Functions 4 November 26th 04 11:12 PM


All times are GMT +1. The time now is 08:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"