Solved

Make a Space in a Cell or Delete the Prefix words

Posted on 2011-03-08
9
179 Views
Last Modified: 2012-05-11
Hi Experts,

Im trying to make a space betwen a link

13.10.09\Aldershot-Chelsea-05.08.02-L.jpg

I want to make a space after " \ A" I need to get a space between the backslash and A.

If this is to difficult to do I would like to remove the 13.10.09\ leaving just the Aldershot-Chelsea-05.08.02-L.jpg alone in the cell.

Please let me know.
0
Comment
Question by:gs1uk
  • 3
  • 2
  • 2
  • +1
9 Comments
 
LVL 6

Expert Comment

by:Eric Zwiekhorst
Comment Utility
insert column after cells holding the JPG name
Put in the first cell after the first picture name this formula: =MID(cell holding picturename,10,30)

Kind regards

Eric
0
 
LVL 6

Expert Comment

by:Eric Zwiekhorst
Comment Utility
If this is not what you need please upload an example sheet so I can see what you mean...


KR

Eric
0
 
LVL 59

Accepted Solution

by:
Chris Bottomley earned 63 total points
Comment Utility
Select the cells then press ctrl and F then type \ as the find string and \ then space in the replace with and enter

Chris
0
 
LVL 59

Expert Comment

by:Chris Bottomley
Comment Utility
Sorry ctrl & H for replace!

Chris
0
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
LVL 19

Assisted Solution

by:MINDSUPERB
MINDSUPERB earned 125 total points
Comment Utility
<If this is to difficult to do I would like to remove the 13.10.09\ leaving just the Aldershot-Chelsea-05.08.02-L.jpg alone in the cell.>

Use this formula



=RIGHT(a1,LEN(B5)-FIND("\",a1))

I assume that the value is in A1.

Sincerely,
Ed
0
 
LVL 19

Assisted Solution

by:MINDSUPERB
MINDSUPERB earned 125 total points
Comment Utility
Sorry,

It must be =RIGHT(A1,LEN(A1)-FIND("\",A1))

Ed
0
 
LVL 50

Assisted Solution

by:teylyn
teylyn earned 62 total points
Comment Utility
Hello,

alternatively, you can use Text to Columns with the \ sign as the delimiter. That will result in your data being split into two columns:

13.10.09  in the first column and  Aldershot-Chelsea-05.08.02-L.jpg in the second column.

Select the cells with the data, then click Data > Text to Columns > Delimited  > Other and enter a \ sign in the box next to Other > Finish

cheers, teylyn
0
 
LVL 50

Expert Comment

by:teylyn
Comment Utility
The added bonus of the Text to Column method is that the cells contain the actual value and not a formula that just displays the value. With any formula solution, you will probably need to copy the result and use Paste Special - Values to get the actual text of the results into their own cells.
0
 
LVL 6

Expert Comment

by:Eric Zwiekhorst
Comment Utility
Hi Teylyn,

The Text to column is only acceptable if you don't have to do it several time a week, or maybe a day..

If the name of the picture is changing regularly it must be a formula..

Kr

Eric
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now