Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Replace formulae works but need to dump the data rather than linking from the origional column

Status
Not open for further replies.

AdamRicko

Technical User
Feb 19, 2009
97
GB
Hi All,

I'm trying to trim/replace a column down to 40 characters. I can use =REPLACE(B1,41,50,"") Which gives me exactly what i want, but it is reliant on the origional data still being available.

I need some kind of way to trim/replace down to a maximum of 40 characters either with the origional data column or make it so it can dump the 40 character text into another column so i can delete/copy/paste the old/new data.

Hope this makes some sense. Please see attached, might make it slightly easier!

Many Thanks,

AR

IT Support

Comptia A+
Comptia Network +
 
hi,

You can use Data > Text to columns - FIXED WIDTH in Step 1, set the FIELD WIDTH LINE to 40 in Step 2, and in Step 3, select Do not import column to the SECOND FIELD (41+).

Skip,
[sub]
[glasses]Just traded in my old subtlety...
for a NUANCE![tongue][/sub]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top