If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Copy part of a cell
My problem, I have a cell which displays a value of 4/abcd1
I want another cell to equal this only without the 4/ ie cell A1 = 4/abcd1 I want cell B1 to = cell A1 but only ignore the first two charters ie cell B1 will return abcd1 How do I do it? cheers |
#2
|
|||
|
|||
Copy part of a cell
Hi
try =MID(A1,3,255) -- Regards Frank Kabel Frankfurt, Germany Suddes wrote: My problem, I have a cell which displays a value of 4/abcd1 I want another cell to equal this only without the 4/ ie cell A1 = 4/abcd1 I want cell B1 to = cell A1 but only ignore the first two charters ie cell B1 will return abcd1 How do I do it? cheers |
#3
|
|||
|
|||
Copy part of a cell
One way is in B1 type
=MID(A1,3,6) this will take the text from the 3rd character and the next 6. If your original data is likely to be longer amend the 6 to whatever you want. Another way in B1 type =MID(A1,FIND("/",A1)+1,6) this allows for different lengths of data before the / i.e. A/abcd1 but will also handle AAA/abcd1 hth Mike --- Message posted from http://www.ExcelForum.com/ |
#4
|
|||
|
|||
Copy part of a cell
Sorted i use =MID formula and it works a treat.
Thanks "Suddes" wrote: My problem, I have a cell which displays a value of 4/abcd1 I want another cell to equal this only without the 4/ ie cell A1 = 4/abcd1 I want cell B1 to = cell A1 but only ignore the first two charters ie cell B1 will return abcd1 How do I do it? cheers |
#5
|
|||
|
|||
Copy part of a cell
If you generally want it to ignore the first two characters then try
=MID(A1,3,LEN(A1)-2) If you want the last four characters, then it is easier with =right(A1,4) LoucaGreen --- Message posted from http://www.ExcelForum.com/ |
#6
|
|||
|
|||
Copy part of a cell
=REPLACE(A1,1,2,"")
"Suddes" wrote in message ... My problem, I have a cell which displays a value of 4/abcd1 I want another cell to equal this only without the 4/ ie cell A1 = 4/abcd1 I want cell B1 to = cell A1 but only ignore the first two charters ie cell B1 will return abcd1 How do I do it? cheers |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Conditional formatting to change colour based on part of a cell | Steve Jackson | Worksheet Functions | 3 | May 12th, 2004 03:50 PM |
Cell range copy to second workbook | GerryK | Worksheet Functions | 2 | March 25th, 2004 05:23 PM |
Do you have what it takes... | Frank Kabel | Worksheet Functions | 1 | February 22nd, 2004 08:30 PM |
HELP! Return data if cell in row contains data | dee | Worksheet Functions | 13 | November 10th, 2003 06:48 PM |