Search results

Hello, I want to separate text that is all one one cell. I'm familiar with the text to column with the delimiters and fixed width. The fixed width works very well, but not all text is lined up appropriately. An example of a text is: Smith, Carol 3334 S. Camelot Way, SLC, UT 84012 (I want to...

I have a spreadsheet of data and one of the columns on that spreadsheet is the month. I enter the month data as January, February...etc. so I just do the month name. I do this so when I create my pivot table, I can look for data for that particular month. When I drag the month over to the pivot...

Never mind Hui...sorry. I know why. Didn't enter anything...:-)

That was fast Hui!Thank you. I put that in and it came up with #value. Do you know why?

I'm trying to return a specific statement depending on what cells are entered. If someone puts text in A7 then that returns a text I want so that was: =IF(ISTEXT(A7),E2,"") Then if someone enters text in A7 and B7, then that returns a different text I want so that was...

Hui, Thanks for the reply. Yes, I did read the post about the photo and list validation. I thought of doing the same thing with what I was going to do. My list will be about 200 signs so I better learn Access. Do you know of any good sites on Access? Thanks.

I have to create a list or a "database" of signs where I work. I'd like to include a picture of the signs and fields that relate to the signs (size of sign, font, floor located...etc). If a sign needed to be updated, then I can simply do a search of a word that would appear on any of the signs...