ScoobyNet.com - Subaru Enthusiast Forum

Notices
Computer & Technology Related Post here for help and discussion of computing and related technology. Internet, TVs, phones, consoles, computers, tablets and any other gadgets.

Excel formula help

   
Old Apr 23, 2009 | 11:18 AM
Share
  #1  
druddle's Avatar
druddle
Thread Starter
Scooby Regular
 
Joined: Mar 2001
Posts: 5,528
Likes: 0
From: Berkshire
Default Excel formula help
Hello all

I have a spreadsheet with column A, cell 1 with some text in it in the form "servername_win2k3.lun". I am trying to work out how to automatically fill in column B, cell 1 with "servername_win2k3.qt" by copying the data in column A, cell 1 and replacing .lun with .qt .

Anyone know how I might be able to do this ?

Dave
Reply
0
Old Apr 23, 2009 | 11:31 AM
Share
  #2  
DJ Dunk's Avatar
DJ Dunk
Moderator
20 Year Member
iTrader: (5)
 
Joined: Nov 2001
Posts: 17,864
Likes: 0
From: Not all those who wander are lost
Default
=SUBSTITUTE(A1,"lun","qt")

. . . should do it fine Dave.
Reply
0
Old Apr 23, 2009 | 11:33 AM
Share
  #3  
DJ Dunk's Avatar
DJ Dunk
Moderator
20 Year Member
iTrader: (5)
 
Joined: Nov 2001
Posts: 17,864
Likes: 0
From: Not all those who wander are lost
Default
Or =SUBSTITUTE(A1,".lun",".qt")

in case 'lun' appears in the filename somewhere else.
Reply
0
Old Apr 23, 2009 | 11:36 AM
Share
  #4  
druddle's Avatar
druddle
Thread Starter
Scooby Regular
 
Joined: Mar 2001
Posts: 5,528
Likes: 0
From: Berkshire
Default
Spot on, thanks Dunk
Reply
0
Old Apr 23, 2009 | 08:17 PM
Share
  #5  
hodgy0_2's Avatar
hodgy0_2
Scooby Regular
15 Year Member
Liked
Loved
Community Favorite
 
Joined: Jul 2008
Posts: 15,634
Likes: 22
From: K
Default
or the concatenate comand
Reply
0
Related Topics
Thread
Thread Starter
Forum
Replies
Last Post
BUGEYE PRODRIVE STI BREAKING(rota's/racebox/whiteline/cusco/prodrive styling/6speed+
Mattybr5@MB Developments
Full Cars Breaking For Spares
28
Dec 28, 2015 11:07 PM
BUGEYE PRODRIVE STI BREAKING(bc br's/rota's/afterburner/6speed/ej207/brembos/prodrive
Mattybr5@MB Developments
Full Cars Breaking For Spares
12
Nov 18, 2015 07:03 AM
Lateral MD321H Billet turbo
leg200
Subaru Parts
5
Oct 7, 2015 07:31 AM
Subaru full forged 2.1 blobeye 468 bhp
Ganz1983
Subaru
5
Oct 2, 2015 09:22 AM
Back to Subforum
Computer & Technology Related
View Next Unread
Video format help


Thread Tools
Search this Thread
Search this Thread:

Advanced Search

Advanced Search
Reply Closed Thread Share
Forum Jump

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