Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
cell a1 mod No(abc??d) cell b1=unit size(10) a1 would be abc10d
example
cell a1 (abcd??ef) cell b1 (10) cell a2 would give answer (abcd10ef) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
cell a1 mod No(abc??d) cell b1=unit size(10) a1 would be abc10d
Try this.. But I am not sure if this is what you are asking.. Put this in A2: =LEFT(A1,FIND("?",A1)-1)&A2&RIGHT(A1,LEN(A1)-FIND("?",A1)-1 -- Bearacad ----------------------------------------------------------------------- Bearacade's Profile: http://www.excelforum.com/member.php...fo&userid=3501 View this thread: http://www.excelforum.com/showthread.php?threadid=57007 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
cell a1 mod No(abc??d) cell b1=unit size(10) a1 would be abc1
I don't think that will work if the number of characters to replace is not 2
(but that may not be a problem -there is, after all, only one example to go on). My two cents: =REPLACE(A1,FIND("?",A1),LEN(A1)-LEN(SUBSTITUTE(A1,"?","")),A2) Of course, I'm assuming there are no stray "?" in the text string (for example, a "?" at the end of a question that is not intended to be replaced). "Bearacade" wrote: Try this.. But I am not sure if this is what you are asking.. Put this in A2: =LEFT(A1,FIND("?",A1)-1)&A2&RIGHT(A1,LEN(A1)-FIND("?",A1)-1) -- Bearacade ------------------------------------------------------------------------ Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016 View this thread: http://www.excelforum.com/showthread...hreadid=570079 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy worksheet1 to worksheet2, keep cell format eg cell size | Excel Discussion (Misc queries) | |||
Multiple cell unit conversion. Please help. | Excel Discussion (Misc queries) | |||
How can I change the size of a cell and hide what is in the cell? | Excel Worksheet Functions | |||
Cell size? Or size limit for Text data type? | Excel Discussion (Misc queries) | |||
SAP BW Report - Putting the Unit of Measure or Currency in another Cell based on Format Cell | Excel Programming |