Thread: How to delete first 6 Digits and one Space from a CELL?
View Single Post
 
Old 08-10-2010, 04:06 AM
nsv nsv is offline Windows XP Office 2003
Novice
  
Join Date: Jul 2010
Location: Denmark
Posts: 17
nsv is on a distinguished road
Default
If the space is missing or you do not have a reliable delimiter you can also use the MID-function:
Quote:
=MID(A1,8,50)
which takes the content of cell A1 from the 8th to the 50th character.

NSV
Reply With Quote