Find text in one column = add "#, " to different column?

Jennifre

Board Regular
Joined
Jan 11, 2011
Messages
147
Hi @Shakehips! :)

Any tips about where I make the substitutions in what you've sent, regarding the col A rows, and col B and C contents? Thank you, Tony!
 

Some videos you may like

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

Snakehips

Well-known Member
Joined
May 17, 2009
Messages
4,912
Office Version
2013
Platform
Windows
@Jennifur !

I'm not sure that I know what you mean about substitutions.
The code should run on the sample data you posted / I think I replicated.
Bedtime here now. If you / I / both are still confused tomorrow then I will need further clarification of your real data set.
 

Jennifre

Board Regular
Joined
Jan 11, 2011
Messages
147
Okay, sleeping @Snakehips, there was a column between "tags" col 1 and col 2. After deleting that and trying again, I get this:

Run-time error '13':

Type mismatch

*I hope this is somehow an easy fix. I am so excited, if this can work! :) Thank you!! :)
 

Snakehips

Well-known Member
Joined
May 17, 2009
Messages
4,912
Office Version
2013
Platform
Windows
Good Morning!
OK, I think my signature just about sums it up. I need clarification of how your data is set up.
The options are...
You provide a specific verbal description
You post representative screenshots
You post a link to a sample file on a third party host such as Dropbox
You PM me and we arrange to exchange a file by email
You resign your current job and get yourself another that does not involve spreadsheets
I 'get a life' and maybe, take up golf instead

Please advise.
 

Jennifre

Board Regular
Joined
Jan 11, 2011
Messages
147
@Snakehips, good morning!

I have an alternative, which I can use just the same, it'll just take longer but not terrible. (Better than manually!)

Here is my data, almost literally:
Columns and data (ea column is 100px wide, like almost, below!), in NOW state:
A--------B--------C--------D--------
word

Columns and data, in DESIRED state:
A--------B--------C--------D--------
word x


Is that easy, or possible?

Thank you, Tony!! BOTH your options are perfect! :)
 

Jennifre

Board Regular
Joined
Jan 11, 2011
Messages
147
SHOOT! THAT did not work at all!! I'll try again, data is this:

Columns and data (ea column is 100px wide, like almost, below!), in NOW state:
A--------B--------C--------D--------
word

Columns and data, in DESIRED state:
A--------B--------C--------D--------
word--------------x


Is that easy, or possible for some formula / function / magic to:
if a certain "word" is in A1, Excel will add a letter x in C1?
The only thing I'd need is that the x be placed on the same row as the "word", but in column C.

Please let me know, @Snakehips, if you are still with your first coffee and toast! :) Thank you so much!! :)
 

Jennifre

Board Regular
Joined
Jan 11, 2011
Messages
147
Here is my data, almost literally:
Columns and data (ea column is 100px wide, like almost, below!), in NOW state:
A--------B--------C--------D--------
word

Columns and data, in DESIRED state:
A--------B--------C--------D--------
word-------------- x


This seems so easy, fingers crossed it actually is!! :)
 

Dan Waterloo

Well-known Member
Joined
Jan 4, 2007
Messages
869
Hi Jennifre,

Try the following formula in cell C2 (I assume there is a header row):

=if(ISNUMBER(SEARCH("word",A2)), "x", "")

And copy this formula down column C as far as you need it.
 

Watch MrExcel Video

Forum statistics

Threads
1,090,404
Messages
5,414,213
Members
403,519
Latest member
ckgyimah

This Week's Hot Topics

Top