Move The Text

Oct 2, 2008

I inherited a spreadsheet from someone who knows nothing of excel, its massive and I'm trying to organize it into an actual spreadsheet instead of some weird note taking program.

Is there an easy way to take a couple of Cells worth of text and move into one cell combined.

I.e.

This is
just one
Example

Above would be one example, there are 3 cells used to input one sentence... I want to move those to one cell to read

This is just one example

There are also cells with Data Separated by a "/" is there a way to separate that quickly without manually typing or reformatting my wrists are starting to hurt

ADVERTISEMENT

Move Text

May 25, 2007

i have copied and paste text and numbers from a file into EXCEL. Now in one column i have the header and 4 lines, ie
Header: Details
Line 1: Email :*
Line 2: Tel : *( )*
Line 3: Fax :*( )*
Line 4: Web address :*

I want to move Line 1 to 4 into different colums for sorting and pivot reasons.

View 9 Replies View Related

Move Cells Containing Text

Apr 9, 2014

I have an Excel sheet with several columns of data, each containing the link to a website. To the far right of this data, I have a column called "Official Source" in which I'd like to copy over any website links containing the phrase "sec.gov" (if there are any, if not than leave the cell blank).

For example, if I have the following data in my sheet:

Column A Column B Column C
[URL].... [URL].... sec.gov/Ar

Than I would want the last source to move to column D -

Column A Column B Column C Column D
[URL].... [URL].... sec.gov/Ar

how to do this?

View 4 Replies View Related

Macro To Move Text

Oct 14, 2009

I am trying to create a macro to do the following (Microsoft Excel 2002 SP3):

1 - Select the text from the active/selected cell (i.e. B1)
2 - Cut the text from B1
3 - Move to the cell directly above the active/selected cell (i.e. A1)
4 - Add a space to the end of whatever text is in A1
5 - Paste the contents that were cut from B1 after the text and space in A1
6 - Delete the row where the text was cut from (i.e. entire row B)

I have never written code for macro's before, only done recording, but just can't seem to get this sequence to work .

View 8 Replies View Related

Search And Move Text

Jun 16, 2008

I am working on a macro and, as part of it, I would like to look at column H of my spreadshet. If the wording in any cell in column H begins with the word, "total" I would like the cell contents of the cell in column G and up one to be dropped down one. Here is an example:

Let's say that the words "total money" is found in cell H2. I would like the cell contents of cell G1 to be moved to G2, making boths cell side-by-side having text in them - G2 and H2.

View 9 Replies View Related

Move Text When There Is A Second Line

Jan 10, 2009

Sheet1

Removed screen shots - Please DO NOT use actual personal information, sample data only! - Moderator

Some of the people on this list have a second name entry on the line below their first name entry. ALL of the people on the list have an Address2 on the line below their Address1.

How would I move the second name entry into the cell next to the first name entry, and then concatenate them, and then also move the Address2 entry into the cell next to Address1 (but not concatenate these)?

Like this:
Sheet1

View 60 Replies View Related

Move Text From Left To Right Of Number?

Apr 4, 2014

In a large database with a large portion of cells that contains a flag to the left of a number "<LD 2.0" what would be the quickest way to move the flag to the left of the number so that it reads "2.0 <LD". This seems like it should be simple to do. I would prefer not to have to use a second cell and formula to do the modification if that makes sense. I'd rather do a "Find and Replace" if possible.

View 5 Replies View Related

Break Up And Move Text To Next Cell

Apr 25, 2009

There are basically four fields of text (date, trans. #, merchant, $ amount) all in one cell that I would like to have in 4 separate columns without having to cut-paste, cut-paste, cut-paste. Is it possible for me to break this information up quickly into 4 separtate columns? I have about 400 lines of text like this and would like to find a faster way to do it.

View 10 Replies View Related

Move Text From End Of String To Beginning

Jun 28, 2013

I have a column which contains a series of alphanumeric characters some start with the alpha characters and others end with them.

As an example ABS1234, 1234ABS, 12k34AB needs to be ABS1234, ABS1234, AB12k34. The number of alpha characters at the end will be a minimum of 2 and a maximum of 3. Is there some way that I can move the Alpha characters, at the end, so that they are always at the beginning of the string?

View 4 Replies View Related

Move Text Into Columns From Rows

Aug 22, 2009

I have a set of data that has a store number in cell A1, the store name in B1 and then the store address in C1, C2, and C3. This pattern repeats for all ~300 stores. I am trying to get all of the store data on one row per store.

I have a set of data that looks like this:

View 6 Replies View Related

Search For The Text And Move Everything Under That Column

Jan 16, 2007

I have some macros that will look for a certain item and then move it somewhere else on the spreadsheet. However, I can't seem to get the code right to skip over the section if the text is not found. I assume it would be easiest to do it with error handling, but the attempts I've made haven't worked.

the macro will search for the text "Name" and move everything under that column elsewhere; then it will do the same for "Date." But currently, if "Name" is not found anywhere on the spreadheet, it will cause an error and ask to end or debug.

View 9 Replies View Related

Move-Cut First Word From Range Of Text

Nov 6, 2006

I have a text string in a cell. it is comprised of a series of numbers and text. i would like to " cut" the first part of the string starting from the first space and paste in the cell to the left. For example.

range("b11") has the following: "This is my example"

I would like to perform the following:

range ("A11") would equal "This"
Range ("b11") would equal "is my example"

(note the space has been completly removed as well)

View 6 Replies View Related

Move Data In Columns If Rows Contains Particular Text

Feb 24, 2014

If the row contains a text like ABC in multiple columns in a sheet it has to copy the whole column from that sheet and paste special into another sheet.

View 2 Replies View Related

Move Text Data To Next Empty Row In Column

Mar 15, 2007

I am importing a 20 character text string (from a barcode scanner) to H2. I need to send that data to the next unused row in Column A (after insuring that no matching text currently exists in Column A-no action taken if matching data is found). I can provide a copy of the sheet, along with a description of the project.

View 2 Replies View Related

Move Text Between Certain Words To Adjacent Cells

Oct 24, 2007

how to cut a string from text and copy it to another cell: Example of a TEXT:..........................

This is Text in one cell - I need to cut the BOLD part. It always ( if appears ) is after statement <b>Kod Producenta</b>: and before <br/> It's not always in the same place. but always between statment above. "<b>Kod Producenta</b>: STRING_THAT_NEED_TO_BE_COPIED_TO_DIFFERENT_CELL <br/>" how can i do it with VBA macro? with cpp would be so much easier but still i need to do this in VBA...

View 6 Replies View Related

Move Mid Text In Cell To Front. Reverse

Mar 5, 2008

I am working with a column which always displays the cell contents with oldest notes by date first, then the newest note last. I would like to have the contents from a cell reversed with the newest user input by date on top which will simply when reading. Here is an example of a cell. The string always starts with (MM/DD/YYYY TT:TT:TT AM, then user name).

12/20/2007 8:27:56 AM MBARNEY Approval not required for this change request. 01/25/2008 10:27:32 AM KVELDANDA Change to Category, Type, Item, Region, Site, Department fields triggered an evaluation of whether or not the Change requires approval. Approval is not required.

View 9 Replies View Related

Move Selected Non-consecutive Text Characters From One Cell To Another

Feb 27, 2014

I am trying to select and move text from one column to another. I have roughly 1,000 cells in column A and I would like to tell Excel to select characters at certain positions and move them into the adjacent column.

I want it to look like this...

column A column B
ABCDEFGHI BCI

Each cell in column A has a 9-letter sequence. I would like to move characters 2,3 and 9 into the adjacent column

View 2 Replies View Related

Move Rows To Worksheets Based On Cell Text In Row

Mar 16, 2008

I download our monthly bank transactions (.csv). I have a workbook with sheets named for each creditor or expense.

I would like move each row, based on the specific word in a cell row, to the specific worksheet.

Here are some typical transactions in the Description column:

Some are specific:
1/7/2008ACH WEB-SINGLE 9085863 VONAGE AMERICA VONAGE
“Moved to the Vonage worksheet.”

Others are not so obvious:
2/1/2008CHECK CARD PURCHASE XXXXX4636 BOSTON MARKET #0450 GREENSBURG PA
“Moved to the Eat Out worksheet.”

2/21/2008CHECK CARD PURCHASE XXXXX4636 ASPCAPS XXXXX0028 MD
“Moved to the ASPCAPS worksheet.”

2/19/2007POS PURCHASE POS54309901 0014264 PITTSBURGH ST GREENSBURG PA
“Moved to the Grocery worksheet.”

I was able to find the following while during a Search:

Move Cells Containing Specific Word In Column To New Sheet

The question was answered, in addition to Dave Hawley, by Bill Rockenbach who inserted the following code - “Sub FindWord()”

Option Explicit
Sub FindWord()
Dim Sentences
Dim Word As String
Dim i As Long
Dim iWordPos As Integer
Dim lRow As Long
Dim sWord As String

If this is a possibility for what I'm looking for, I’m not sure how to implement it into my situation.

View 6 Replies View Related

Move Rows Based On Specific Text Being In Column

Mar 21, 2008

I am trying to have rows moved from (Schedule) to (Complete) in the attached workbook. The criteria to have the row moved would be the user-selected "Status" list changing to "COMPLETE" in Column G.

I would like to have the row cut and deleted from Sheet4 (Schedule) once "COMPLETE" is selected from the list in Column G with rows below moving up. The row would then be inserted into Sheet2 (Complete) at the top of the list (Row 7) and rows would move down below the new entry. I would also like to have the formatting remain uniform (every other row fill)

View 2 Replies View Related

Move Data From One Column To Another Based On Column Headers And Row Text

Feb 7, 2014

I am in need of restructuring a spreadsheet of addresses for mailing purposes. (I tried to find something similar answered previously, but nothing seemed to work for me.)

I have attached a small example spreadsheet below, but our spreadsheets can be hundreds or thousands of rows in length.

I need a macro that will look for the "PO Box" addresses under the column headers named "ADDRESS2" and "ADDRESS3".

The PO Box addresses will need to be moved under the column header "ADDRESS1" within the same row.

It will need to overwrite the text that is already under "ADDRESS1" and delete the text from the "ADDRESS2" and "ADDRESS3" columns - UNLESS the text in 'ADDRESS2" is a PO Box AND "ADDRESS1" begins with "c/o".

If the data in "ADDRESS2" or "ADDRESS3" is anything other than a PO Box it will remain the same. As will "ADDRESS 1".

Basically if there is a PO Box it needs to be in the column named "ADDRESS1" and overwrite anything else that was there. The exception will be for PO Boxes that are in c/o someone else, the PO Box will then need to be listed in the column directly after the column that has c/o.

If the c/o exception will be too difficult the code could just highlight those scenarios and we could fix them manually. We usually do not have a lot of them, but enough that we need to be mindful of them.

The different scenarios are listed in my sample spreadsheet.Also, the code will have to use the column header names in row 1 because those headers are not always in the same column.

View 14 Replies View Related

Is There A Way To Stick A Few Row Of Cells Together So That When I Move One They All Move

Jul 7, 2009

is there a way to stick a few row of cells together so that when i move one they all move.. i have some rows that when i sort them i want them to move together with the other ones..

View 9 Replies View Related

Move Part Of Text In Cell To Another Cell

May 17, 2006

It's difficult to explain, the attached shows the situation better. Basically there's a picture that is somehow linked to a cell. But, you can update the picture or the cell and the other one gets updated.

View 3 Replies View Related

Move Certain Text In Column C To Column E

Feb 16, 2010

I'd like a macro that finds all cells in column C with the text "Apple" and moves all those cells values (text) to column E.

Case InSensItive.

One Caveat though, the search must continue and not stop searching until it is equal to the bottom-most row of data in column F.

I don't want this macro to search all 1 Million + Rows.

View 9 Replies View Related

Excel Text Search Through Different Types Of Text And Action Based On Text

Oct 14, 2008

1. Search an excel sheet "column" for a particular type of text and insert values based on that text (if found) in another column.

e.g I have column A1 to A10 with different types of text. I would like to search for the keyword "Risk is high" OR "Risk=High" for each cell in the column and insert a "1" if found beside it's corresponding "B" column. If not found, I would like to insert a "0".

So, if the text "Risk is high" OR "Risk=High" was only found in A6, I would like B6 to be "1". Rest of the values in the B column would be "0's", since the text was not found in any of the other cells.

View 10 Replies View Related

Text File Import With Text To Columns Splitting Same Text Differently

Nov 21, 2007

I have a macro which imports data from a mainframe dump text file and performs 'Text to Columns' on the imported data so that formula in the spreadsheet can act on the data. The code works perfectly well when I use it, but if a different user logs on and performs exactly the same mainframe dump and import macro the Text to Columns action splits the raw data in a different way and the result is that the split renders the formulae useless.

I've experimented a little and for some reason it appears that the 'Field Info' parameters which are produced when the Text to Columns function is recorded in a macro differ between users even though the raw data is exactly the same.

FieldInfo:= _
Array(Array(0, 1), Array(18, 1), Array(35, 1), Array(56, 1), Array(70, 1), Array(88, 1), _
Array(102, 1))

View 6 Replies View Related

If Anything In Col B>1 Then Move That Row.

Apr 21, 2008

How would one go about making a module that would tell Sheet1 that if any number in column B is greater than 1 then take the contents of the row that number is in and copy it to Sheet2? Attached is an example of the workbook.

View 10 Replies View Related

VBA To Move A Row Up When Value Is Not Zero

May 31, 2007

I have 8 rows (B345:B352) that have a formula similar to this:=IF(Site1!B53>0,CONCATENATE(Site1!$B$53," Scansys 942 @ ","$",Site1!D53,".00"),""). By the way, can the formula be shortened? I tried formatting the merged cell but nothing changes.
When Site1!B53=0, then there's nothing in the cell.That's how I want it. But say, row 3, Site3!$B$53 >0 how do I programatically move (copy/paste?) row 3 to row 1 (since row 1 and row 2 are blank)? In other words, Since rows 1 & 2 is blank, I don't want the two empty rows there, so I would like to move row 3 up to row1.

View 9 Replies View Related

Move Row Up Or Down

Mar 10, 2009

I have a workbook with several sheets each containing different numbers of rows. These rows contain data from clients (codes etc applying to motors). The rows have been randomly populated and I am having to move rows from somewhere in the sheet up or down so the codes are grouped according to which motor they apply to.

What I want to do is select a row and be able to run a macro that will move it where I want. The destination can be up or down and any number of rows away. Does anyone have any ideas how to do this? I was thinking that if I selected the row I wanted to move and the one I wanted to move it to then run the macro it could be moved. Its not to replace the destination row, but be inserted alongside it.

View 9 Replies View Related

Move Selection One To The Right?

Mar 18, 2014

For a specific equation to work I need to know the distance whenever the acceleration is maximum.

The last part is a piece of cake, using MAX I get the desired results.

However, returning the distance is difficult.

What I'd like to do is return the value of the cell to the right of the maximum acceleration.

Using

=ADDRESS(MATCH(MAX(K2:K754);K2:K754;0);COLUMN(K2:K754))

I got the address of MAX, but that's about as far as I get.

View 9 Replies View Related

Move To Another Cell

Nov 30, 2008

I have got a problem with moving to another cell. For example, I click A1, the active cell is A1, then I wanna move to B1. I usually just need to use the right arrow on my keyboard to move. But this time, it didn't move - instead, it moves the scroll bar.

View 2 Replies View Related

How To Move Around Without Unselecting

Jun 27, 2009

I've got a selected area and a button I've got to click on. I can't see them both on the screen at the same time.

If I try to move from the selected area to the button the selected area becomes unselected!

How do I keep it selected?

That's the problem and the question. If you'd like to know the background it is this:

I need to put a spreadsheet into a web page and I downloaded a macro that will generate slim html code for you, for any spreadsheet.

This is it. When I ran it I discovered it opened in its own spreadsheet with this button to get it started once you've pasted into it the spreadsheet or part of a spreadsheet that you want converted.

Makes it nice and easy. Easier than bothering to import a macro into your own spreadsheet.

View 10 Replies View Related

Move Tab To New Workbook?

Jan 22, 2013

I tried to move a tab to a new Excel workbook. You may say that it is very straightfward to do it: right click the tab and then do 'move' or 'create a copy'.

I found the problem is that the whole color will be completely changed and look bizarre. I really like to get a genuine copy of the tab: all remains the same.

View 5 Replies View Related

How To Move Parts Of A Row

May 30, 2014

I am trying to move some parts of a row (From G:AE) where text is found in G Column. It moves it back 1 column from G

[Code] .....

Attached File : ozeform.csvā€ˇ

View 4 Replies View Related

If Cell Contains Value Then Move It?

Feb 15, 2014

In column F if a cell contains the word Test I want it to copy the cell where it is found and paste the value of it exactly 4 cells to the left.

View 1 Replies View Related

Move Row To Next Available Row VBA Code?

Mar 7, 2014

I could get a code to move a row from one area of a worksheet to another area on the same worksheet once a cell is tagged "Paid" via a refreshed macro. The updating data table starts on Row 3 for columns "B" - "R." The paid table starts on row 56 where column "B" always has a date in its cell.

View 7 Replies View Related

Copy Instead Of Move

Dec 1, 2008

Can this code be modified to copy pictures rather than move them? I want to keep them in a tidy library column A:A. The workbook finds a picture based on the picklist, it is an example I found online but I need it to copy and paste the picture (and leave the original where it is).

F1 cell
=VLOOKUP(A2, PicTable, 2, FALSE) this is connected to a 2 column validation table called picTable that has names in the first column (values in the picklist) and picture names in the second column (which corrosponds to the actual picture names)

Also, long after they have been copied, I need to clear all of what I have copied (with a macro button), but when I record a macro to do this it doesnt work because the copied "picture number' changes each time it is copied and the recorded macro only deletes the picture object number that I deleted when recording it!

View 4 Replies View Related

Move Cells On Same Row

Dec 5, 2008

I am trying to move the data in a row from cell D thru I (eye) to cell H thru M.
Simply move it all over a few cells. Well not so simply.

The line in RED fails.

View 7 Replies View Related

Move One Cell To Another..?

Dec 16, 2008

I require code which will transfer text+numerical data from column K to column I (same row) and numerical data in Column I to one row above. I enclose an attachment by way of illustration. Actual s/s is 332324 rows deep - making manual changes impractical.

View 2 Replies View Related

Move One Column To The Right

Nov 10, 2009

I am trying to move one column to the right each time the macro is ran. Next time it should go from columns B:B to C:C

View 12 Replies View Related

Cut And Move From Row 2 To Final Row?

Jun 14, 2012

I need to cut and move data in a worksheet where the bottom always changes. The header row should stay in worksheet 1 and row 2 down to the bottom needs to be cut and moved to worksheet 2. One time it could be 100 rows and the next time a thousand or more.

View 5 Replies View Related

Move A Range Using VBA?

Feb 16, 2013

I have a small formatting issue in my excel spreadsheet.

I would like to move cells in the form below:

1

0

95

35

21

2

12

110

272

14

To:

1
2

0
12

95
110

35
272

21
14

View 4 Replies View Related

ADVERTISEMENT