Ask your question
Message list Discussion Forum list
Report

Excel: use if to find & change text in column [Solved]

dobeekioskea 1Posts February 8, 2010Registration date - Feb 9, 2010 6:50am GMT - Last answer on Feb 9, 2010 9:47am GMT venkat1926
Hello,

i want to search column "a" with numbers as text as follows:

#305
#777
#78
#82
#884

i need a formula that will search column A and change any two digit numbers to three digit with a leading zero. i want the change to take place within the existing data in column a so that example data:

a1 lkjljlk blah #305
a2 dkfjalfj blah #55

would end up as

a1 lkjljlk blah #305
a2 dkfjalfj blah #055

thanks and thanks to everyone for all this great information on this site

vista
excel 2007
firefoxConfiguration: Windows Vista Firefox 3.5.7
Read more ...

Excel: use if to find & change text in column »

I have an answer
Add comment

Best answers

 Excel: use if to find & change text in column - Search

 In Excel, how do I find if text in column A also exists in Column B? - Forum

Best answer: user vlookup formula if you have same name in second column =vlookup(select any one name in column A prefer first name , then select full range of column B then ,1,FALSE)

 Excel change text box colour based on cell value - Tips

Excel - Text box linked to cell value Issue Solution Note Issue I have a text box placed in a chart that links to another sheet/cell for its content. The value is a percentage. I can format the source text using conditional format,...

 Change Text color Depending On Formula Result in excel - Forum

Best answer: You are true. But it satisfies only for three options

 Format date change text in excel - Forum

Best answer: First an important note: when typing a date into a cell you can't type it with dots like 12.1.2008 (Excel won't understand that as a date) but you have to type it with slashes: 12/1/2008 now for your question: You can format the date in a cel

 Changing excel cell from formula to normal text - Forum

Best answer: Hi, Try with this macro : Sub DysplayFormula() Range("A6").Value = "'" & Range("A4").Formula & "" End Sub Hope this will work as you want. Best regards

 Change text file name using excel macro given in sheet - Forum

Best answer: Give this a try! ' ******************************************************************************** Sub test2() Sheets("WS To be Loaded into").Select ' Where to load csvs load_csv 65, "A988", "A1:D2", "\first.csv" 'A998 is destination cell, A

 Excel 2003 change text to date - Forum

Best answer: This assumes that the data is in column A and that row 1 has header info. So, it starts checking in row 2 of column A. Also, by using the Do loop until empty assumes there are no blank cells in the column. Otherwise, the For loop will need to

 Excel - Use if to find & change text in column - Tips

Excel - Use if to find & change text in column Issue Solution Note Issue I want to search column "a" with numbers as text as follows: #305 #777 #78 #82 #884 I need a formula that will search column A and change any two...

 Excel: use if to find & change text in column - Tips

Excel: use if to find & change text in column Issue Solution Note Issue I want to search column "a" with numbers as text as follows: #305 #777 #78 #82 #884 I need a formula that will search column A and change any two...

 Excel - Run Macro on Cell Change - Tips

Excel - Run Macro on Cell Change Issue Solution Note Issue I am trying to have 1 of 8 different macro's run depending on the value of a specific cell. If I enter 1 in cell A3, I would like macro1 to run. If I change cell A3 to 2, I...

 Excel - Compare two lists and change row color - Tips

Excel - Compare two lists and change row color Issue Solution Note Issue I have two different workbooks; let's say workbook 1 and workbook2. In both workbooks I have a column with barcodes. I need a VBA to check the two barcode...

 Excel 2003 IF Function using Dates & Text - Forum

Best answer: your date entry is in A1 try this formula =IF(AND(A1>="1/1/94"+0,A1<="12/31/95"+0),"U16",IF(AND(A1>="1/1/96"+0,A1<="12/31/97"+0),"U14",IF(A1>=1/1/98,"U12",""))) study this carefully so that you an create such a formula in future remember in e

 Excel: Convert Oz. to milliliters inside Text - Forum

Hello, I&apos;ve been looking for a solution for the following issue: I have a very long excel list of product description that contain product with OZ value. For example: Bottle A is 4 Oz I would like to convert the OZ to milliliters so that I could...

 MS Excel - VBA, Writing to Text File (Columns - Forum

Thanks for the help in advance. I have an Excel file with data in Columns. A_____________________B_____________________C_____________________... ___________________Date 1__________________Date 2___________________ ... Station 1____________Depth...

 Excel - Prefix 0 to all records in a column - Tips

Excel - Prefix 0 to all records in a column Issue Solution Note Issue I want to prefix 0(zero) to all records in a particular column of an excel sheet.Please let me know how to do it? Solution If the data in numeric then select the...

More
Sort by :   Vote | Date | Date descending 1 answers
Best answer
+1
moins plus
venkat1926 767Posts June 14, 2009Registration date September 9, 2010Last seen Feb 9, 2010 9:47am GMT
suppose a1 to a5 is
305
777
78
82
884

in B1 type thisformula
=IF(LEN(A1)=2,"0"&A1,A1)
copy B1 down
highlight B1 down
edit copy
highlight B1 only
edit -pastespecial-choose values and click ok
now delete column A

do this as an experimetn and you will get hang of i t.

 Add comment - Permalink (#1)
Add comment
Top
See also
supinfo