LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default chop off extra characters in excel

I am looking for a way to remove extra charaters from a number, and
copy it to a new column. Column B is generated from column A. For
example:
A = B
11005656552 565655
11004567754 456775
13117896432 789643

Thanks for you help!

 
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
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
Cyrillic characters in excel cyrilastin Excel Discussion (Misc queries) 2 May 23rd 06 05:57 PM
Can I use a header or footer more than 255 characters in Excel? Jin Qingfeng Excel Discussion (Misc queries) 1 December 15th 05 12:07 PM
Can I use a header or footer more than 255 characters in Excel? Jin Qingfeng Excel Worksheet Functions 0 December 15th 05 02:22 AM
How to remove an extra line added by excel when pasting into notep CoolGuy Excel Discussion (Misc queries) 1 March 2nd 05 02:57 PM


All times are GMT +1. The time now is 02:34 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"