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 23 April 2009, 11:18 AM
  #1  
druddle
Scooby Regular
Thread Starter
 
druddle's Avatar
 
Join Date: Mar 2001
Location: Berkshire
Posts: 5,528
Likes: 0
Received 0 Likes on 0 Posts
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
druddle is offline  
Reply Like
Old 23 April 2009, 11:31 AM
  #2  
DJ Dunk
Moderator
Support Scoobynet!
iTrader: (5)
 
DJ Dunk's Avatar
 
Join Date: Nov 2001
Location: Not all those who wander are lost
Posts: 17,863
Received 0 Likes on 0 Posts
Default
=SUBSTITUTE(A1,"lun","qt")

. . . should do it fine Dave.
DJ Dunk is offline  
Reply Like
Old 23 April 2009, 11:33 AM
  #3  
DJ Dunk
Moderator
Support Scoobynet!
iTrader: (5)
 
DJ Dunk's Avatar
 
Join Date: Nov 2001
Location: Not all those who wander are lost
Posts: 17,863
Received 0 Likes on 0 Posts
Default
Or =SUBSTITUTE(A1,".lun",".qt")

in case 'lun' appears in the filename somewhere else.
DJ Dunk is offline  
Reply Like
Old 23 April 2009, 11:36 AM
  #4  
druddle
Scooby Regular
Thread Starter
 
druddle's Avatar
 
Join Date: Mar 2001
Location: Berkshire
Posts: 5,528
Likes: 0
Received 0 Likes on 0 Posts
Default
Spot on, thanks Dunk
druddle is offline  
Reply Like
Old 23 April 2009, 08:17 PM
  #5  
hodgy0_2
Scooby Regular
 
hodgy0_2's Avatar
 
Join Date: Jul 2008
Location: K
Posts: 15,633
Received 21 Likes on 18 Posts
Default
or the concatenate comand
hodgy0_2 is offline  
Reply Like
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
28 December 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
18 November 2015 07:03 AM
Lateral MD321H Billet turbo
leg200
Subaru Parts
5
07 October 2015 07:31 AM
Subaru full forged 2.1 blobeye 468 bhp
Ganz1983
Subaru
5
02 October 2015 09:22 AM
Back to Subforum
Computer & Technology Related
View Next Unread
Video format help




Advanced Search
Quick Reply: Excel formula help


Reply Closed Thread Share
Forum Jump

All times are GMT +1. The time now is 10:05 PM.