| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Replace Function
I've used this feature a lot, but can't seem to get this task
accomplished... I have a column with numbers, but the first character is an apostrophe ('). I want to removed this character from this column so I can format the column successfully. Thoughts?? Thanks for your help! |
|
#2
|
|||
|
|||
|
Replace Function
In a helper column, try:
=SUBSTITUTE(A1,"'","") Copy down as needed. Then copy the helper column and using 'Paste Special' -Values, paste the date back to the original column. Regards, Paul "DNA" wrote in message lkaboutsoftware.com... I've used this feature a lot, but can't seem to get this task accomplished... I have a column with numbers, but the first character is an apostrophe ('). I want to removed this character from this column so I can format the column successfully. Thoughts?? Thanks for your help! |
|
#3
|
|||
|
|||
|
Replace Function
Worked perfectly, thank you!
|
|
#4
|
|||
|
|||
|
Replace Function
Hi DNA
In a helper column, say with your data in A2, enter the formula =A2*1 That will convert it from text to numbers -- ve_2nd_at. Stilfontein, Northwest, South Africa "DNA" wrote: I've used this feature a lot, but can't seem to get this task accomplished... I have a column with numbers, but the first character is an apostrophe ('). I want to removed this character from this column so I can format the column successfully. Thoughts?? Thanks for your help! |
|
#5
|
|||
|
|||
|
Replace Function
Yep, that one worked as well, Can't figure out why I didn't think of some
of these. Thank you ALL so much for your help! |
|
#6
|
|||
|
|||
|
Replace Function
Simply open and close TTC.
Select the column of numbers, then: <Data <TextToColumns <Finish And you're done! -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "DNA" wrote in message lkaboutsoftware.com... I've used this feature a lot, but can't seem to get this task accomplished... I have a column with numbers, but the first character is an apostrophe ('). I want to removed this character from this column so I can format the column successfully. Thoughts?? Thanks for your help! |
|
#7
|
|||
|
|||
|
Replace Function
Wow, very smart, that worked great as well!
Thank you very much! |
|
#8
|
|||
|
|||
|
Replace Function
You could also enter a 1 into another cell, highlight that cell and copy it
(ctrl+c or edit-copy), then select your cells containing the apostrophe and select edit-paste special from the menu, select multiply as the operation, and hit OK. "DNA" wrote: I've used this feature a lot, but can't seem to get this task accomplished... I have a column with numbers, but the first character is an apostrophe ('). I want to removed this character from this column so I can format the column successfully. Thoughts?? Thanks for your help! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA function for "Mean" using Array as argument | Excel Worksheet Functions | |||
| creating function (vba) with range arguments | Excel Worksheet Functions | |||
| REPLACE outside of highlighted column | Excel Worksheet Functions | |||
| Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
| HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
Hybrid Mode
