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

Thread Tools
 
Search this Thread
 
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




Advanced Search
Reply Closed Thread Share
Forum Jump

All times are GMT +1. The time now is 06:13 AM.